Homework #2 Please upload your homework as a Word document to Canvas by March 10

Question

Homework #2 Please upload your homework as a Word document to Canvas by March 10 given sample data and normalize it into a A bookstore uses the following table to store data. Review this table along with the set of tables that are all in third normal form (3NF). Please be sure that every 3NF tables has primary key underlined (and if a table's PK is not listed in the table given below, please add a PK columns so all normalized tables have primary key) * The same book may be published in one ore more formats such as paperback, hardcover, and digital. Regardless of the format the same book has same ISBN, title, authors/s, publisher, and customer rating. Each format of the same book may have a different retail price . Display your answer as a list of tables without the data - as an example, see this customer table from a different database: CUSTOMER (Customer, Customer-Address, Phone#1 . Please write your answers in a Word document, write your full name at the top of the document, save the document as your last-name-first-initial.docx, and upload it to Canvas. . Book Format Book ISBN Book Title Author First Name Eric Eric Holden Author Last Name Retail Price Publisher Name Year Published Average Customer Ratin 4.5 o Starc No Starch Press O'Reilly Media 1593276036 Digital hon Crash Course Learning Spark Mat 19.16 2016 1449358624 1449358624 1491943203 High Performance Spark Paperback 1491943203High Performance Spark|Digital 17.44 8.95 24.83 19.99 2015 2017 2017 2017 Konwiski Learning Spark Digita Holden Karau Holden Rachel Holden Rachel O'Reilly Media O'Rcilly Media O'Reilly Media Warren Karau Warren

Explanation / Answer

functional dependencies

ISBN -> Title,AverageCustomerRating,PublisherName

ISBN -> Format (multivalue attribute)

ISBN -> YearPublished(multivalue attribute)

Format ->RetailPrice

ISBN ->FirstName,LastName (multivalue attribute)

Tables in 3NF

BOOK(ISBN ,Title,AverageCustomerRating,PublisherName ,YearPublished)

BOOKFORMAT(ISBN , Format )

BOOKPRICE(ISBN,Format,RetailPrice)

PUBLISHEDYEAR(ISBN,YearPublished)

AUTHOR(FirstName,LastName , ISBN)

underlined are primary keys

underlined are primary keys

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.