Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

Table 1: Home Library ISBNTitle 369852 Cosmos 741258 No Secrets 654789 Symphony No 3 Dur Eroica Op 55 789654 On the Decay of the Art of Lying 258963 The Adventures of Sherlock Holmes Conan Doyle 125896 The Divine Come 357951 The Hitchhikers Guide to the Galaxy 852369 The Return of the King, Soundtrack 831975 Unseen Academicals Author LastName Author FirstName Publis her Sagan Simon Beethovern Twain Carl ar Ludwig Mark Date Edition Media 1980 1 1972 1 1805 1 Random House CD CD eBook eBook eBook Elektra Project Gutenberg1880 1 Project Gutenberg Project Gutenberg Pan books Reprise Doubleday ur lighieri dams Dante Douglas Howard Terry 1979 11 2003 1 2009 1 Shore CD Pratchet 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 3. Draw the Relational Schema for each of these 3NF relations and show the referential integrity constraints that apply