Models data as fact types in a fact-based scheme
Elementary fact types with roles, uniqueness and mandatory constraints
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 | 91% | Mastered |
| gemini-3.5-flash-lite | Low cost | 10% | Not shown |
| gpt-6-luna | Low cost | 9% | Not mastered |
| claude-haiku-5-5 | Low cost | 90% | 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: Elementary fact types with roles, uniqueness and mandatory constraints
How it is assessed: From 'each account is held by at least one customer' and 'a customer may hold several accounts': the fact type customer holds account, with the uniqueness spanning both roles and the account role mandatory
Related knobits
Builds on
All 59 knobits of Derive the logical data model.
Source: DAMA-DMBOK2 chapter 5, element(s) DM-12: a performance at CDMP Practitioner level