Data modelling - Standard
1NF
(First Normal Form)
A database rule that says each field should hold one value, not a list of values
What's it for?
Keeps data in a simple, consistent structure so individual values can be stored, searched and updated cleanly.
Often confused with…
- 2NF (Second Normal Form)A database rule that moves information out when it depends on only part of a combined key
- 3NF (Third Normal Form)A database rule where non-key information depends directly on the record's key
- NormalisationOrganising a database so each fact is stored cleanly with minimal unnecessary duplication