Skilirium

Designs a document structure for a stated access pattern

K-673 · Skill knobit · Activity: Design the physical data model · Competence: Data modelling

Documents shaped by the reads they serve, with the duplication and its update rule stated

Can AI do this?

AI does this partly Some of the tested AI models master this; others do not show it. 2 of 4 models in the current benchmark master it.

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 90%Mastered
gemini-3.5-flash-liteLow cost 11%Not shown
gpt-6-lunaLow cost 90%Mastered
claude-haiku-5-5Low cost 90%Not shown

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: Documents shaped by the reads they serve, with the duplication and its update rule stated

How it is assessed: For a mobile banking statement read by account and month: one document per account-month embedding its transactions, with the duplicated account name and how it is refreshed stated

Related knobits

Builds on

All 47 knobits of Design the physical data model.

Source: DAMA-DMBOK2 chapter 5, element(s) DM-14: a performance at CDMP Practitioner level