Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Screenshot check please

1 answer below »
Answered Same Day Apr 16, 2020

Solution

Navashree answered on Apr 21 2020
145 Votes
Solution.docx
Solution
The given table in its un-normalized form is,
1. From the data given in the table, it can be seen that the ISBN is unique for each row of data. Hence, the attributes, Title, Author_LastName, Author_FirstName, Publisher, Date, Edition, Media, are dependent on the ISBN attribute. So, the dependency diagram is given below.
The functional dependency is,
ISBN Title, Author_LastName, Author_FirstName, Publisher, Date, Edition, Media
The diagram representing the same is,
2. First, the table contains data about books, authors, publishers. Now, it is clear that no book has multiple authors. However, there are anomalies and NULL values in the database. The primary aim of the normalization process is to reduce the anomalies by preserving the functional dependencies in the initial table (Garcia-Molina, Ullman, & Widom, 2013). One example of an anomaly is, if the details of the publisher Elektra is needed to be removed, then the details of the book ‘No Secret’ and the author ‘Carly Simon’ will be removed...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here