Recognises a deletion anomaly in a logical data model
Deleting one fact deletes another that should have survived.
Can AI do this?
People still lead Few or none of the tested AI models showed they master this. 0 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 42% | Not shown |
| gemini-3.1-pro-preview | Flagship | 42% | Not shown |
| gpt-6-astra | Flagship | 43% | Not shown |
| claude-fable-5-1 | Flagship | 42% | Not shown |
| gemini-3.8-flash | Mid tier | 44% | Not shown |
| gpt-6.1-sol | Mid tier | 42% | Not shown |
| claude-sonnet-5-5 | Mid tier | 43% | Not shown |
| gemini-3.5-flash-lite | Low cost | 49% | Not shown |
| gpt-6-luna | Low cost | 42% | Not shown |
| claude-haiku-5-5 | Low cost | 43% | Not shown |
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 deletion and the fact that would be lost with it
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: Branch BIC held only on Account; the branch's last account is closed and purged and the BIC goes with it Acceptable: Branch holds the BIC; Account references Branch
Also known as: Deletion anomaly (logical model)
Related knobits
Builds on
Needed for
All 56 knobits of Derive the logical data model.
Source: Review checklist 05-logical, row 3; Codd 1971; Fagin 1981; E&N 14.1.2; C&B