The dependency diagram in Figure indicates that authors are paid royalties for each book that they write

Question:

The dependency diagram in Figure 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 eachtable.