Stage 5: Derive the logical data model
Knobit of Data modelling · K-556 · Knowledge
Explains third normal form
What it means
No non-prime attribute depends transitively on a candidate key.
How it is assessed
Classifies sample entities as in or not in 3NF and names the transitive dependency
Builds on
- Explains candidate key and prime attributeK-552 · Knowledge
Needed by
- Recognises a transitive dependency between non-key attributesK-509 · Skill
- Explains Boyce-Codd normal formK-557 · Knowledge
- Explains controlled denormalisationK-651 · Knowledge