First+Normal+Form

The next step is to produce the data in First Normal Form (1NF). First Normal Form removes the repeating group and puts it into a new relation and then linking it to the original relation

1. Remove the repeating groups to a new entity 2. Identify the primary key of the new entity 3. Create a foreign key in the new entity to connect it to the original entity

**Example**

Working with our courses entity from Unnormalised Form...

...follow the steps to show the data in First Normal Form (1NF)


 * 1. Remove the repeating groups to a new entity **




 * 2. Identify the primary key **




 * 3. Add a foreign key **