Explains identifying and non-identifying relationships
Whether a child entity's key includes its parent's key, and dependent versus independent entities.
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 | 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 | 91% | Not shown |
| 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: Whether a child entity's key includes its parent's key, and dependent versus independent entities
How it is assessed: Classifies sample relationships as identifying or non-identifying and gives the child's key
Related knobits
Builds on
Needed for
- K-534 Resolves a many-to-many relationship into an associative entity
- K-535 Replaces a repeating group with a dependent entity
All knobits of Data modelling.
Source: DAMA-DMBOK2 chapter 5, section 1.3.3.3