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

Task Normalisation Using the given table/relation, do the following: Draw a dependency diagram to show the functional dependencies in the relation Decompose the following table into a set of 3NF relations Draw a relational schema for your 3NF relations and show the referential integrity constraints. Manually drawing the dependency diagrams is not acceptable.