Normalisation

Normalisation

1. A series of steps which are carried out to improve the integrity of data in a database

   • Integrity means free from errors

2. 1st form

   • Must have a primary key
   • Must be in simplest form - atomic data
   • Must have a unique table name
   • No repeated or similar field names

3. 2nd form

   • All non key fields must relate to the primary key
     • Fields must relate to the purpose of the table

4. 3rd form

   • No non-key fields can rely upon other non-key fields
   • The 1st and 2nd form normalisation should already be normalised