Question: I need your help in making my assignment. This assignment should be submitted to Turnitin as a MS Word document.

Your Dependancy Diagrams could be inserted as images into your MS Word document or drawn in MS Word. These are just the assignments.

you dont have to write lengthy pages.

Normalisation

Value: 15%

Submission method options

Alternative submission method

Task

Using Table 1: GRADE REPORT relation above

1. Draw a dependency diagram to show the functional dependencies in the relation 
2. Decompose GRADE REPORT into a set of 3NF relations
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints

NOTE

Manually drawing the dependency diagram or the relational schema is NOT acceptable.

Online submission via Turnitin is required for this assignment. Details will be provided by your subject lecturer.

Rationale

1. This assessment item is designed to test your understanding of more advanced database design, your ability to use an iterative approach to modelling, and to examine data problems due to redundancy.
2. Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.