The dependency diagram shown 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.$ Remove all partial and transitive dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created. Show all dependency diagrams and relational schema for $2$NF and $3$NF

$2.$Draw the Crows Foot ERD.