Submission method optionsAlternative submission method Task Table 1: Home Library ISBN Title Author_LastName Author_FirstName Publisher Date Edition Media 369852 Cosmos Sagan Carl Random House 1980 1...

Table 1: Home Library

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.

NOTE

For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.youtube.com/watch?v=vkUyuLLgmwQ

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

This assessment aligns with the following subject outcomes:

• be able to critically analyse a database design and apply normalisation theory and techniques;

Requirements

Either save yourdiagrams in aPDF file or embedthem in a Word document.

Don't use any other file formats

Please include your student ID, name and subject code inyour submission.