The dependency diagram (see attached) indicates that authors are paid royalties for each book they write for a puvlisher. The amount of the royalty can vary by author, by book, and by edition of the book.

1. Based on the dependency diagram, create a database whose tables are at least in 2NF, showing dependency diagram for each table
2. Create a database whose tables are at least in 3NF, showing dependency diagram for each table.

Use draw. io to draw your database / dependency diagrams.

ISBN Book Title Author_Num LastName Publisher Royalty Edition