Draw a dependency diagram
Home Library
ISBNTitleAuthor_LastNameAuthor_FirstNamePublisherDateEditionMedia
369852CosmosSaganCarlRandom House19801Book
741258No SecretsSimonCarlyElektra19721CD
654789Symphony No 3 Dur Eroica Op 55BeethovenLudwig 18051CD
789654On the Decay of the Art of LyingTwainMarkProject Gutenberg18801eBook
258963The Adventures of Sherlock HolmesConan DoyleArthurProject Gutenberg 1eBook
125896The Divine ComedyAlighieriDanteProject Gutenberg 1ebbok
357951The Hitchhikers Guide to the GalaxyAdamsDouglasPan books19791Book
852369The Return of the King, SoundtrackShoreHowardReprise20031CD
831975Unseen AcademicalsPratchettTerryDoubleday20091Book
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.
Answers
Status NEW
Posted 22 May 2017 05:05 AM
My Price 8.00
-----------
Attachments
file 1495432290-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am
-----------
Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------.
-----------
Th-----------ank----------- yo-----------u
-----------
Not Rated(0)