Normalisation
What is normalisation?
Normalisation is the process of creating a database structure that has the best possible design. There are three stages of this. 1NF, 2NF and 3NF.
| 0NF | 1NF | 2NF | 3NF |
|---|---|---|---|
| A flat file database | No columns with repeated data | Must have 1NF rules | Must have 1NF and 2NF rules |
| Each row is unique with a primary key | Each of the fields must rely on the primary key | No field should rely on another non key field E.g A DB cant store age and DOB | |
| Each fields must have a unique name |