Decomposes an entity along a functional dependency without loss
Repairs a normal-form violation by moving the determinant and its dependents into an entity of their own, losslessly and preserving dependencies.
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 | 98% | Mastered |
| gemini-3.1-pro-preview | Flagship | 98% | Mastered |
| gpt-6-astra | Flagship | 96% | Mastered |
| claude-fable-5-1 | Flagship | 98% | Mastered |
| gemini-3.8-flash | Mid tier | 96% | Mastered |
| gpt-6.1-sol | Mid tier | 98% | Mastered |
| claude-sonnet-5-5 | Mid tier | 99% | Mastered |
| gemini-3.5-flash-lite | Low cost | 41% | Not shown |
| gpt-6-luna | Low cost | 98% | Mastered |
| claude-haiku-5-5 | Low cost | 97% | 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: Two or more entities that join back to exactly the original rows and keep every dependency enforceable
How it is assessed: The shared attributes are a key of one part, no dependency is left spanning two entities, and the dependent attributes move with their determinant
Related knobits
Builds on
All 56 knobits of Derive the logical data model.
Source: Stage 5 reference (references/05-logical.md) and the skill-tests logical-model task