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.