Need help to answer the question a and b.

9. 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 ISBN BookTitle Author Num LastName Publisher Royalty Edition Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table a. Create a database whose tables are at least in 3NF, showing the dependency diagram for each table.I b