Hand Clean up the Book Details in the Database

User Story

• As a: user,
• I want: accurate information about books
• so that: I get as much information as possible when looking at the books from this site.

Functional Requirements

NOTE: All edits must appear in: src/db/create_tables_load_content.sql

• Replace all nulls in "AmazonDetails".num_reviews with actual number (0, 1, 4, whatever is actually there)
• Replace all nulls in "AmazonDetails".rating with actual decimal
• Replace all nulls in "AmazonDetails".synopsis with a book synopsis looked up on google
• Remove duplicate authors from "Author" and update all references in "AuthorBooks"
  1. Find duplicate author name in "Author" (ex: 'J.K. Rowling')
  2. Take note of the larger numbers (those you must replace with the lowest id)
     • 137, J.K. Rowling
     • 343, J.K.Rowling
  3. Update all references in "AuthorBooks", replace 343 with 137
     • UPDATE public."AuthorBooks" SET author_id=137 WHERE author_id=343;
  4. Delete the author with id 343 from the table "Author"
     • DELETE FROM public."Author" WHERE author_id=343;

Description

This task is just manual work with lots of copy and paste. You don't need to complete all of them, but spend a couple hours and get most of them done.