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.