Please enable JavaScript.
Coggle requires JavaScript to display documents.
3
Normalisation (Overview (What is normalisation?, Normalisation…
3
Normalisation
-
-
-
2nd Normal Form
-
Consider whether the PK logically determines the attribute
and not whether the attribute is determined by the PK
(the latter is what 3NF is about...)
-
3rd Normal Form
-
-
Advantages
-
-
Simpler maintenance, no inconsistencies
-
Un-normalised
form (UNF)
-
Repeated sets of attributes for lists, e.g.
supplier-num-1, supplier-name-1,
supplier-num-2, supplier-name-2 etc...
-