The dependency diagram below 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. 1. Identify and discuss each of the indicated dependencies. 2. Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table. 3. Create a database whose tables are at least in 3NF, showing the dependency diagram for each table