Designs a star schema for a stated grain
A fact table at the stated grain with additive measures and conformed dimensions
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.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 90% | Not shown |
| gemini-3.5-flash-lite | Low cost | 90% | Mastered |
| gpt-6-luna | Low cost | 90% | Mastered |
| claude-haiku-5-5 | Low cost | 89% | 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: A fact table at the stated grain with additive measures and conformed dimensions
How it is assessed: For card transactions at one row per authorised transaction: the fact holds amount and fee at that grain, dimensions for date, card, merchant and account are conformed, and no measure is at a coarser grain
Related knobits
Builds on
All 47 knobits of Design the physical data model.
Source: DAMA-DMBOK2 chapter 5, element(s) DM-10: a performance at CDMP Practitioner level