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

The dependency diagram below indicates that authors are paid royalties for each book they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book.

(10)

a)

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

(8)

(8)