Skilirium

Replaces a repeating group with a dependent entity

K-535 · Skill knobit · Activity: Derive the logical data model · Competence: Data modelling

Moves numbered or listed attributes into an entity of their own, so any number of occurrences can be recorded.

Can AI do this?

AI does this well Most of the tested AI models master this. 9 of 10 models master it.

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 100%Mastered
gemini-3.1-pro-previewFlagship 100%Mastered
gpt-6-astraFlagship 100%Mastered
claude-fable-5-1Flagship 100%Mastered
gemini-3.8-flashMid tier 100%Mastered
gpt-6.1-solMid tier 100%Mastered
claude-sonnet-5-5Mid tier 100%Mastered
gemini-3.5-flash-liteLow cost 33%Not shown
gpt-6-lunaLow cost 99%Mastered
claude-haiku-5-5Low cost 96%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 dependent entity with its own identifier, one row per occurrence

How it is assessed: Every repeated property moves to the new entity, which has its own identifier and no fixed upper limit

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