Recognises a relationship contradicting its data rule
The relationship's cardinality, optionality or identifying flag says something different from the data rule it cites.
Can AI do this?
AI does this well Most of the tested AI models master this. 8 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.1-pro-preview | Flagship | 100% | Mastered |
| gpt-6-astra | Flagship | 83% | Not shown |
| claude-fable-5-1 | Flagship | 99% | Mastered |
| gemini-3.8-flash | Mid tier | 100% | Mastered |
| gpt-6.1-sol | Mid tier | 100% | Mastered |
| claude-sonnet-5-5 | Mid tier | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 34% | Not shown |
| gpt-6-luna | Low cost | 100% | Mastered |
| claude-haiku-5-5 | Low cost | 100% | Mastered |
Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.
What it looks like in practice
Expected result: The relationship, the rule it cites and the cardinality or optionality that differs
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: BR-007: each payment is posted to exactly one account, but LR-004 has parent_optional: true Acceptable: Read each relationship aloud as a sentence and compare it with the rule word for word (LOG-011, LOG-029 find a missing link; a mismatch needs a person)
Also known as: Relationship contradicts its data rule (logical model)
Related knobits
Builds on
All 56 knobits of Derive the logical data model.
Source: Review checklist 05-logical, row 29; this skill (05-logical.md §4c)