Resolves a many-to-many relationship into an associative entity
Turns a many-to-many relationship into an entity of its own so that its facts (roles, dates, shares) have a place.
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 | 75% | 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: An associative entity carrying the relationship's facts, with cardinality stated in both directions
How it is assessed: The facts of the relationship live on the associative entity, its cardinality is stated both ways, and attributes duplicated elsewhere to stand in for it are removed
Related knobits
Builds on
- K-567 Explains relationship cardinality and optionality
- K-904 Explains identifying and non-identifying relationships
All 56 knobits of Derive the logical data model.
Source: Stage 5 reference (references/05-logical.md) and the skill-tests logical-model task