Normalization Exercise:

Assignment Objectives:

On successful completion of the Computer Assignment, students will demonstrate the ability to:

1. Consolidate the knowledge gained in doing the practical exercises using Microsoft Access during the semester.
2. Link the database concepts acquired from the lectures/homework to the practical exercises using Microsoft Access in the Computer Lab.
3. Normalise a spreadsheet of data into tables in the third normal form in order to eliminate data anomalies.

Weighting, Availability and Due date of the Assignment

1. The assignment is to normalise a spreadsheet of data into tables in the third normal form(3NF). It is worth 10% of the overall marks for the unit.
2. Details of the assignment and the required data files are available from the Unit vuws site. 3. The assignment due date is below:

Your job is to normalize the data below from 0NF to 3NF