Chapter 6 Review Question & Problem Text Chapter 6 - Review Question 7 7. The dependency diagram in Figure Q6.7 indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book. Figure Q6.7 Book royalty dependency diagram a. Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table. b. Create a database whose tables are at least in 3NF, showing the dependency diagram for each table. Chapter 6 - Problem 5 5. To keep track of office furniture, computers, printers, and so on, the FOUNDIT company uses the table structure shown in Table P6.5. Table P6.5 Sample ITEM Records Attribute Name ITEM_ID ITEM_LABEL ROOM_NUMBER BLDG_CODE BLDG_NAME BLDG_MANAGER Sample Value 231134-678 HP DeskJet 895Cse 325 NTC Nottooclear I. B. Rightonit Sample Value 342245-225 HP Toner 325 NTC Nottoclear I. B. Rightonit Sample Value 254668-449 DT Scanner 123 CSF Canseefar May B. Next a. Given that information, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. b. Write the relational schema and create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary. c. Draw the Crow's Foot ERD