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. 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.