Skilirium

Stage 3: Document data rules as SBVR fact types and rule statements, Stage 6: Design the physical data model, Stage 8: Generate and review DDL

Knobit of Data modelling · K-310 · Skill

Recognises a constraint claimed by a rule and missing from the schema

What it means

`enforcement: constraint` where the physical model carries no matching constraint.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: A mandatory rule whose column is `nullable: true` Acceptable: Either the column is `NOT NULL`, or the rule's enforcement is honestly `dq-check` (`ANO-010`)

Needed by

  • None