==================

DATABASE DESIGN PROBLEM.

NOTE*: I have to help someone who is not physically here finish his assignment, but I've never learned anything about database. Show me the right way please. Do you have to use SQL to solve this problem? Read carefully and full answers will be greatly rated. thanks.

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 r elation into the third normal form. Identify all intermediate steps