7. The dependency diagram in Figure Q6.7 indicates that authors are paid royalties for each book they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of...

database and design how to create the illustration for this with labeled primary keys

Extracted text: 7. The dependency diagram in Figure Q6.7 indicates that authors are paid royalties for each book 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 ISBN BookTitle Author Num LastName Publisher Royalty Edition 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. 8. The dependency diagram in Figure Q6.8 indicates that a patient can receive many prescriptions for one or more medicines over time. Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table. Figure Q6.8 Prescription Dependency Diagram Shelflife MedName PatientID Date RefillsAllowed PatientName Dosage