This paper circulates around the core theme of :1.Draw a dependency diagram to show the functional dependencies that exist in this relation. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 24. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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.