Using the given table/relation, do the following: 1. Draw a dependency diagram to show the functional dependencies in the relation 2. Decompose the following table into a set of 3NF relations 3. Draw...

Using the given table/relation, do the following:


1.    Draw a dependency diagram to show the functional dependencies in the relation


2.    Decompose the following table into a set of 3NF relations


3.    Draw a relational schema for your 3NF relations and show the referential integrity            constraints


4.    Manually drawing the dependency diagrams is not acceptable.