Data modelling - Process
3NF
(Third Normal Form)
A database rule where non-key information depends directly on the record's key
What's it for?
Reduces duplication and inconsistency by keeping each fact with the main thing it describes.
Often confused with…
- 1NF (First Normal Form)A database rule that says each field should hold one value, not a list of values
- 2NF (Second Normal Form)A database rule that moves information out when it depends on only part of a combined key
- NormalisationOrganising a database so each fact is stored cleanly with minimal unnecessary duplication