Task should be done in software. Home Library ISBN Title Author_LastName Author_FirstName Publisher

Task should be done in software. Home Library ISBN Title Author_LastName Author_FirstName Publisher Date Edition Media 369852 Cosmos Sagan Carl Random House 1980 1 Book 741258 No Secrets Simon Carly Elektra 1972 1 CD 654789 Symphony No 3 Dur Eroica Op 55 Beethoven Ludwig 1805 1 CD 789654 On the Decay of the Art of Lying Twain Mark Project Gutenberg 1880 1 eBook 258963 The Adventures of Sherlock Holmes Conan Doyle Arthur Project Gutenberg 1 eBook 125896 The Divine Comedy Alighieri Dante Project Gutenberg 1 ebbok 357951 The Hitchhikers Guide to the Galaxy Adams Douglas Pan books 1979 1 Book 852369 The Return of the King, Soundtrack Shore Howard Reprise 2003 1 CD 831975 Unseen Academicals Pratchett Terry Doubleday 2009 1 Book Tasks: Using the Home library relation above: Draw a dependency diagram to show the functional dependencies that exist in this relation. Decompose the Home Library relation into a set of 3NF relations and draw a dependency diagram for each of the 3NF relations. Develop the Relational Schema for each of these 3NF relations and show the referential integrity constraints that apply. Rationale This assessment item is designed to test your ability to Gather, analyse and model business requirements using Enhanced Entity Relationship Diagrams (EERD), Critically analyse a database design and apply Normalisation Theory and techniques. Marking criteria Marking Rubric Task HD DI CR PS FL Draw a dependency diagram to show the functional dependencies in the Home Library relation The dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependencies The dependency diagram accurately identifies and correctly shows all PKs and most functional, partial, and transitive dependencies The dependency diagram identifies and shows most PKs and some functional, partial, and transitive dependencies The dependency diagram identifies and shows few PKs and few functional, partial, and transitive dependencies The dependency diagram identifies and shows few or no PKs and few or no functional, partial, and transitive dependencies Decompose the Home Library relation into a set of 3NF relations The set of relations is in 3NF and accurately identifies all PKs and all the relevant attributes The set of relations is in 3NF and accurately identifies all PKs and most of the relevant attributes The set of relations is in 3NF identifies most PKs and some of the relevant attributes The set of relations is mainly in 3NF and identifies some PKs and some of the relevant attributes The set of relations is not in 3NF and identifies few or no PKs and few or none of the relevant attributes Draw a relational schema for each of the 3NF relations and show the referential integrity constraints The relational schema accurately describes each entity and correctly shows all of the referential integrity constraints The relational schema accurately describes each entity and correctly shows most of the referential integrity constraints The relational schema describes each entity and shows some of the referential integrity constraints The relational schema describes most entities and shows some of the referential integrity constraints The relational schema describes few entities and shows few or none of the referential integrity constraints Marking Guide Task Marks Score Task 1: Dependency diagram 25 Task 2: 1. All entities identified 15 2. PKs identified 10 3. Attributes identified for each entity 10 Task 3: 1. Relational schema for each entity 10 2. Attributes correctly described 10 3. PKs correctly described 10 4. FKs correctly described 10 Total 100 Final mark 15



Price: £ 96

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh