The following table shows a relation called AUTHOR BOOK ROYALTIES for a law firm specialized in textbook author contracts. It represents information about textbooks such as the author, the textbook they wrote and the publisher including author royalties. The Author number (ANbr) is unique for each author and is sufficient to obtain information about the author name and its institution name. Each book is assigned a unique number (BNbr) providing information about the book name, its publisher and its price. The publisher city can be derived from the publisher name. Finally, each royalty is specific to each author for a given book. Author Book Royalties ANDr Alname AFname Alnst BNB BName BPublish PubCity BPrice AuthBRoyalty 10 Gold Josh Sleepy Hollow 106 JavaScript and HTML5 Wall & Vintage Chicago, IL $62.75 S6 28 10 Gold Josh Sleepy Hollow 102 Quick Mobile Apps Gray Brothers Boston, MA $49.95 52 50 24 Shippen Mary Green Lawns 104 Innovative Data Management Smith and Sons Dalas, TX $158 65 $15.87 24 Shippen Mary Green Laans 106 JavaScript and HTML5 Wall & Vintage Chicago, IL 562.75 $6.00 32 Oswan Jan Middlestate College 126 Networks and Data Centers Gray Brothers Boston, MA $250.00 $12.50 32 Oswan Jan Middlestate College 180 Server infrastructure Gray Brothers Boston, MA $122 85 $12.50 32 Oswan Jan Middlestate College 102 Quick Mobile Apps Gray Brothers Boston, MA $49.95 52 25 a. (3 pts) Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown. Indicate which attributes you choose as candidate keys and indicate the different type of dependencies (Full, Partial, Transitive) a. (3 pts) Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown. Indicate which attributes you choose as candidate keys and indicate the different type of dependencies (Full, Partial, Transitive) b. (1 pt) What is normalization form of the diagram drawn in a. C. (2 pts) Transform the diagram in a 2NF form d. (2 pts)Transform the diagram in a 3NF form and show the referential integrity constraints. e. (2 pts) Develop an E-R diagram with the appropriate cardinality notations (optional and mandatory not required)