Question $3(10$ pts$)$

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.

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 $2$NF form

d$.(2$ pts$)$Transform the diagram in a $3$NF 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$).$

Please answer completely, anwers will get a thumbs up$.$ Thank you