Data modelling - Standard
2NF
(Second Normal Form)
A database rule that moves information out when it depends on only part of a combined key
What's it for?
Reduces repeated data by making sure information is stored with the thing it actually describes.
Often confused with…
- 1NF (First Normal Form)A database rule that says each field should hold one value, not a list of values
- 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