Stage 3: Document data rules as SBVR fact types and rule statements
Knobit of Data modelling · K-311 · Skill
Recognises a uniqueness rule with no unique key behind it
What it means
A uniqueness rule marked as enforced, with no primary key or unique constraint covering those columns.
How it is assessed
Flags the deficient case and passes the acceptable one. Deficient: `BR-2: no two accounts share an IBAN`, `enforcement: constraint`, and no `uk_` on that column Acceptable: A unique constraint on the natural key, or the rule reassigned to a DQ check with a threshold (`ANO-012`)
Builds on
- Explains rule enforcement mechanisms and platform enforcementK-356 · Knowledge
- Explains candidate key and prime attributeK-552 · Knowledge
Needed by
- None