Charlie has a large book collection. He was keeping track of it in a spreadsheet, but it has grown big enough that he wants to c

Question

2 months ago

10

Charlie has a large book collection. He was keeping track of it in a spreadsheet, but it has grown big enough that he wants to c

onvert it into a real database. Here is a sample from the spreadsheet: Author James Taylor Author Country England May Norton United States Titles JavaScript Essentials, South Tech Books, London, 2010, $14; HTML5 Exposed, Webby Books, London, 2012, $15.50 Big Data Big Promise, Data Press, San Francisco 2012, $25 Database Development for the Cloud, Data Press San Francisco, $20.35; Data Services, Future Tech Press, New York $12.95 Jessica Lewis United States Ques. 1. What are some of the potential problems with this layout if carried directly to the database? (Exam2.docx) Ques. 2. Create the Dependency Diagram and transform it into the highest normal form (Show various stages - INF, 2NF, 3NF). Be sure to show the primary keys, and various dependencies in each stage (Exam2.docx) Ques. 3. Create the final ER diagram that shows the database in the highest Normal Form. (Indicate PK, FK, data types). You can add additional attributes as needed. (Exam 2.docx) Ques. 4. Write a single script file (Label it as Exam2.sql) to create the tables and insert the sample data in Oracle. Confirm that the rows are created, and data is inserted. Use echo and spool to create an output file (Label it as Exam2_Output.txt)

Computers and Technology

1 answer:

Harlamova29_29 [1K] · Answer 1 · 2026-02-28T04:22:37+03:00

Answer:

Review the explanation

Explanation:

Response 1) Keeping all data in a single row presents challenges; if one record in the sheet is deleted, all related records may also vanish unexpectedly. For instance, should the entry for author "James Taylor" be removed, all the books associated with him would get eliminated as well.

Response 2) In the first normal form (1NF), each row is supposed to have just one tuple, but in the case of the author "James Taylor," the title field contains two books, necessitating separation into distinct rows.

Response 3) The table shown in the image does not exhibit deletion anomalies; for the author "May Norton," if you erase this record, it will result only in the deletion of her sole book.

Thus, it’s essential to transition this table into the second normal form (2NF).

Create distinct tables for Authors and Books

Authors(Author Name, Author Country)

Books(Author Name, Book Title, Publisher, Publisher Location, Year, Price)

This cannot undergo further normalization.