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. Manually drawing the dependency diagrams is not acceptable.