7.(7.) The dependency diagram in Figure Q6.7 indicates that authors are paid royalties for cach book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book. (12 points-6part a, 6 part b) Figure Q6.7 Book royalty dependency diagram ISBN Book Title Author Num LastNamePublisher Royalty Edition Based on the dependency dia dependency diagram for each table. (6 points- expeet 3 tables/dependeney diagrams) Create a database whose tables are at least in 3NF, showing the dependency diagram for each table (6 points expect 4 tables/ dependency diagrams) create a database whose tables are at least in 2NF, showing the a. gram, b