Stage 5: Derive the logical data model
Knobit of Data modelling · K-552 · Knowledge
Explains candidate key and prime attribute
What it means
A candidate key is a minimal set of attributes that determines all others; a prime attribute belongs to a candidate key.
How it is assessed
Finds every candidate key of a sample entity from its dependencies and classifies its attributes as prime or non-prime
Builds on
- Explains functional dependencyK-551 · Knowledge
Needed by
- Recognises a uniqueness rule with no unique key behind itK-311 · Skill
- Records the functional dependencies of an entityK-532 · Skill
- Explains second normal formK-555 · Knowledge
- Explains third normal formK-556 · Knowledge
- Explains domain-key normal formK-561 · Knowledge
- Explains lossless-join decompositionK-563 · Knowledge
- Explains natural keys, surrogate keys and key stabilityK-568 · Knowledge
- Explains identifying and non-identifying relationshipsK-904 · Knowledge