Recognises an unresolved many-to-many relationship
An N:M relationship left in the model. Its facts (dates, shares, roles) have nowhere to live, and they are usually requirements not yet captured.
Can AI do this?
AI does this well Most of the tested AI models master this. 9 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 | 100% | Mastered |
| claude-fable-5-1 | Flagship | 100% | 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 | 79% | 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 and the facts that have nowhere to live
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: Account N:M Party "is held by", with holder role and start date in nobody's attributes Acceptable: Account Holder associative entity with holder role and start date (LOG-010)
Also known as: Unresolved many-to-many (logical model)
Related knobits
Builds on
Usually followed by
All 56 knobits of Derive the logical data model.
Source: Review checklist 05-logical, row 21; C&B; this skill