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.

Transcribed Image Text:

TABLE 4-9 Author Book Royalties AID ALname AFname Alnst 0 Gold BPublish PubCity wall &Chicago, I BPrice AuthBRoyalty $62.75 $6.28 BNbr BName 106 Javascript 102 Quick Mooile 104 Inrovative 106 JavaScript losh Sleepy Hallow U and HTML!5 Boston, MA $49.95 2.50 24 Shippen ary Green Smith Ca as, TX and Sons Wall & Indianapolis, IN vintage Grey Brothers Gray $158.65 $15.87 Daa Management and HTML5 Data Certers 2.75 S6.00 Boston, NH $50.00 $12.50 ston, MA 122.5 $12.30 Boston, MA $45.00 $2.25 32 0wan Jan Middlestate 126 Neworks and College 180 Server 102 Quck Mobile