Josh Part 2 Bottom up database design. Normalize AuthorBook Table (Modified from Question 4-54 in Textbook) TABLE 4-9 Author Book Royalties AID Alname Afname Alnst BNbr BName BPublish PubCity BPrice AuthBRoyalty 10 Gold Sleepy 106 JavaScript Wall & Chicago, IL $62.75 $6.28 Hollow U and HTML5 Vintage 102 Quick Mobile Gray Boston, MA $49.95 $2.50 Apps Brothers 24 Shippen Mary Green 104 Innovative Smith Dallas, TX $158.65 $15.87 Lawns U Data Management and Sons 106 JavaScript Wall & Indianapolis, IN $62.75 $6.00 and HTML5 Vintage 32 Oswan Jan Middlestate 126 Networks and Grey Boston, NH $250.00 $12.50 College Data Centers Brothers 180 Server Gray Boston, MA $122.85 $12.30 Infrastructure Brothers 102 Quick Mobile Gray Boston, MA $45.00 $2.25 Apps Brothers a. What is the current normal form for Table 4-9 Author Book Royalties? Justify your answer. b. What is the primary key? C. Move the table into 1NF. d. Write down functional dependencies including (partial, transitive and full dependencies). e. Move write down the tables into 2NF by removing partial dependency. List all the tables in 2NF. f. Move write down the tables into 3NF by removing transitive dependencies. List all the tables in 3NF. g. Write down referential integrities between all the tables in 3NF in the AuthorBook Relational Database. h. Write down ERD for the conceptual design of the AuthorBook Database