Recognises a constraint implied by neither keys nor domains
A constraint that neither a key nor an attribute's domain enforces. Each one is a way in for rows 1–3.
Can AI do this?
Not tested yet
No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.
What it looks like in practice
Expected result: The constraint and why no key or domain enforces it
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)
Also known as: Constraint not implied by keys and domains (DKNF) (logical model)
Related knobits
Builds on
All 56 knobits of Derive the logical data model.
Source: Review checklist 05-logical, row 30; Fagin 1981