Skip to main content

Converting to First Normal Form (1NF)

To convert the entity to First Normal Form (1NF) we must:

  • remove the repeating group of attributes to form a new entity
  • add to it the original key

The following document shows this stage of Normalisation

We now have two entities linked by the Course Code key. This means that each student in the class is represented by an entry in the second table so now there is no problem with varying numbers of students

Next: Converting to Second Normal Form (2NF)