Stage 5: Derive the logical data model
Knobit of Data modelling · K-568 · Knowledge
Explains natural keys, surrogate keys and key stability
What it means
What makes a key stable and meaningless, and why a natural key is kept as a unique identifier.
How it is assessed
Classifies sample keys as stable or not and meaningful or not, and says which to keep as natural keys
Builds on
- Explains candidate key and prime attributeK-552 · Knowledge