Records the functional dependencies of an entity
Writes down which attributes determine which, from the business rules, so that every normal-form judgement rests on stated dependencies.
Can AI do this?
AI does this well Most of the tested AI models master this. 9 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 99% | Mastered |
| gemini-3.1-pro-preview | Flagship | 99% | Mastered |
| gpt-6-astra | Flagship | 98% | Mastered |
| claude-fable-5-1 | Flagship | 98% | Mastered |
| gemini-3.8-flash | Mid tier | 97% | Mastered |
| gpt-6.1-sol | Mid tier | 99% | Mastered |
| claude-sonnet-5-5 | Mid tier | 99% | Mastered |
| gemini-3.5-flash-lite | Low cost | 64% | Not shown |
| gpt-6-luna | Low cost | 99% | Mastered |
| claude-haiku-5-5 | Low cost | 98% | 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: The entity's functional dependencies written as determinant -> dependents
How it is assessed: Every dependency the business rules imply is written down, read from the rules and not from the attribute names
Related knobits
Builds on
Usually followed by
- K-508 Recognises a partial dependency on a composite key
- K-509 Recognises a transitive dependency between non-key attributes
- K-511 Recognises a non-superkey determinant in a 3NF entity
All 56 knobits of Derive the logical data model.
Source: Stage 5 reference (references/05-logical.md) and the skill-tests logical-model task