Assignment title: Information


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.