Explains controlled denormalisation
A copy or merge kept consistent by a stated mechanism and checked.
Can AI do this?
AI does this well Most of the tested AI models master this. 10 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 | 100% | Mastered |
| 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: A copy or merge kept consistent by a stated mechanism and checked
How it is assessed: Decides for sample denormalisations what keeps them consistent
Related knobits
Builds on
Needed for
- K-601 Recognises an unmanaged duplicate column
- K-602 Recognises logical entities merged into one table
- K-909 Explains NoSQL data modelling schemes
All 40 knobits of Design the physical data model.
Source: Data-management practice used by the stage 6 reference and review checklist