Tasks: Using the Home library relation above: 1. Draw a dependency diagram to show the functional dependencies that exist in this relation. 2. Decompose the Home Library relation into a set of 3NF...

Tasks:
Using the Home library relation above:
1.    Draw a dependency diagram to show the functional dependencies that exist in this relation.
2.    Decompose the Home Library relation into a set of 3NF relations and draw a dependency diagram for each of the 3NF relations.
3.    Develop the Relational Schema for each of these 3NF relations and show the referential integrity constraints that apply.