Stage 5: Derive the logical data model
Knobit of Data modelling · K-532 · Skill
Records the functional dependencies of an entity
What it means
Writes down which attributes determine which, from the business rules, so that every normal-form judgement rests on stated dependencies.
How it is assessed
Every dependency the business rules imply is written down, read from the rules and not from the attribute names
Builds on
- Explains functional dependencyK-551 · Knowledge
- Explains candidate key and prime attributeK-552 · Knowledge
Needed by
- None