Task: 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.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here