Article

Normalisation (Normal Factor)

computer-science databases

Warning

This document has AI generated images.

Normalisation is a process used to produce the most optimal design for a database.

It requires that tables should be organised as so data is not duplicated in the same table or different tables; permitting complex queries to be made.

There are three fundamental stages.

1NF

0NF - 1NF (AI generated - Gemini).png

“The data must depend on the key”

  • No repeating attributes
  • Attributes must be atomic

2NF

1NF - 2NF (AI generated - Gemini).png

“The data must depend on the whole key”

  • No partial dependencies

3NF

2NF - 3NF (AI generated - Gemini).png

“The data must depend on nothing but the key”

  • No non-key dependencies