Stage 5: Derive the logical data model
Knobit of Data modelling · K-510 · Skill
Recognises a stored derivable attribute
What it means
An attribute whose value can be computed from other attributes, stored and writable alongside them, so the stored and computed values can disagree.
How it is assessed
Flags the deficient case and passes the acceptable one. Deficient: Balance with Ledger Balance Amount, Hold Amount and Available Balance Amount all captured; Repayment Schedule with Total Repayment Amount alongside its instalments Acceptable: Available balance derived, with `derivation` and the rule cited (available balance = ledger balance − holds); total repayment stored only as the amount contracted, with `derivation` saying it is not recomputed (see data rules row 6)
Builds on
- Explains derived data and point-in-time snapshotsK-565 · Knowledge
Needed by
- Recognises a stored derived or summary valueK-603 · Skill