Explains attribute domains
An attribute has one meaning, one type and one set of allowed values.
Can AI do this?
AI does this well Most of the tested AI models master this. 10 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.1-pro-preview | Flagship | 100% | Mastered |
| gpt-6-astra | Flagship | 100% | Mastered |
| claude-fable-5-1 | Flagship | 100% | Mastered |
| gemini-3.8-flash | Mid tier | 100% | Mastered |
| gpt-6.1-sol | Mid tier | 100% | Mastered |
| claude-sonnet-5-5 | Mid tier | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 100% | Mastered |
| gpt-6-luna | Low cost | 100% | Mastered |
| claude-haiku-5-5 | Low 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: An attribute has one meaning, one type and one set of allowed values
How it is assessed: Names the domain of each attribute of a sample entity and finds the attribute whose meaning varies
Related knobits
Needed for
- K-505 Recognises an attribute holding several facts
- K-506 Recognises an attribute with several meanings
- K-507 Recognises attributes held as name-value rows
- K-522 Recognises a polymorphic association
- K-561 Explains domain-key normal form
- K-617 Recognises a physical domain differing from the logical domain
- K-817 Recognises a length taken from sample data
All 56 knobits of Derive the logical data model.
Source: Normalisation theory and relational design (Codd, Fagin, Date), as used by the stage 5 reference and review checklist