Skilirium

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)

Needed by