Using above table 1. Draw a dependency diagram to show the functional dependencies in the relation 2. Decompose the relation into a set of 3NF relations 3. Draw a relational schema for your 3NF relations and show the referential integrity constraints 4. Create an ERD that represents your 3NF relations 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. Requirements Either save your diagrams in a PDF file or embed them in a Word document.