Explore the data included in Table 4-9. Assume that the primary key of this relation consists of

Question:

Explore the data included in Table 4-9.
Assume that the primary key of this relation consists of two components: Author's ID (AID) and Book number (BNbr). The relation includes data regarding authors, books, and publishers. In addition, it tells what an individual author's per book royalty amount is in the case of multi-authored books.
Your task is to:
a. Identify the functional dependencies between the attributes.
b. Identify the normal form in which the relation currently is.
c. Identify the errors in the data that have been made possible by its poor structural characteristics.
d. Take the actions (if any) necessary to convert the relation into the third normal form. Identify all intermediate steps.

image text in transcribed
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Modern Database Management

ISBN: 978-0133544619

12th edition

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

Question Posted: