Stage 5: Derive the logical data model
Knobit of Data modelling · K-565 · Knowledge
Explains derived data and point-in-time snapshots
What it means
A derivable value can be computed and need not be stored; a snapshot keeps a value as it stood and is not derived.
How it is assessed
Classifies sample attributes as derivable, snapshot or base data and says what each derivation reads
Builds on
- None
Needed by
- Recognises a stored derivable attributeK-510 · Skill
- Recognises a redundant relationshipK-526 · Skill
- Recognises an unmanaged duplicate columnK-601 · Skill
- Recognises a stored derived or summary valueK-603 · Skill
- Recognises a hierarchy encoded redundantlyK-608 · Skill
- Recognises a derived or copied column without a checkK-704 · Skill