Skilirium

Introduces subtypes for attributes applying to only some instances

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

Replaces optional attributes that are optional only because they do not apply to some instances with subtypes, so a null no longer means two things.

Can AI do this?

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

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 100%Mastered
gemini-3.1-pro-previewFlagship 96%Mastered
gpt-6-astraFlagship 67%Not shown
claude-fable-5-1Flagship 100%Mastered
gemini-3.8-flashMid tier 100%Mastered
gpt-6.1-solMid tier 68%Not shown
claude-sonnet-5-5Mid tier 100%Mastered
gemini-3.5-flash-liteLow cost 45%Not shown
gpt-6-lunaLow cost 100%Mastered
claude-haiku-5-5Low 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: Subtypes carrying the attributes that apply to them, each mandatory where it applies

How it is assessed: Each attribute sits on the subtype it applies to and can be mandatory there; the exclusivity is written down

Related knobits

Builds on

Usually followed by

All 56 knobits of Derive the logical data model.

Source: Stage 5 reference (references/05-logical.md) and the skill-tests logical-model task