Knobit of Data modelling · K-703 · Skill

Recognises a constraint deferred without a check

What it means

A rule that should be a constraint but cannot be created yet because legacy rows violate it, and that has become nothing in the meantime. Deferral without a check is retirement nobody announced.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: `BR-007: each account has an IBAN`; 3 % of migrated rows have none, so `account_identifier` was made nullable "for now"; no DQ rule, no date Acceptable: `DQ-009` at `threshold: "97%"`, a `comment` naming the repair work and the date the column becomes `NOT NULL` and the threshold 100 %

Builds on

Explains rule enforcement mechanisms and platform enforcementK-356 · Knowledge
Explains the population, measure and threshold of a checkK-753 · Knowledge

Needed by

None