Knobit of Data modelling · K-530 · Skill

Recognises a constraint implied by neither keys nor domains

What it means

A constraint that neither a key nor an attribute's domain enforces. Each one is a way in for rows 1–3.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: Account Closed Indicator typed Text; Account Status Code with no value set; "a currency code has 3 characters" only in a description Acceptable: Domain given by `logical_type`, `length` and `value_set`; every remaining constraint is a key or a data rule with an enforcement (`LOG-007`, `LOG-009`, `LOG-014`, `LOG-028`)

Builds on

Explains domain-key normal formK-561 · Knowledge

Needed by

None