Unnormalised+Form

The first step in normalisation is to show the data in unnormalised form. This means carrying out the following steps:

1. List all of the attributes, only showing any attribute once 2. Identify (underline) the primary key from the list of candidate keys 3. Identify (indent) the repeating group of attributes 4. Name the relation


 * Example **

A school stores all of it's course details in record cards with one record card for each course. A student may take several courses, and teachers may teach more than one course. A sample record card is shown below



Follow the steps to show the data in unnormalised (UNF) form


 * 1. List all the attributes **




 * 2. Identify the primary key **




 * 3. Identify the repeating groups **


 * 4. Name the relation **