Explains how database tables and relationships are structured
Explains the structure of a relational database; does not cover creating a database.
Can AI do this?
AI does this well Most of the tested AI models master this. 4 of 4 models in the current benchmark master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 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 explanation of the structure of a database, with an example
How it is assessed: Explains the meaning of a table, a column, a primary key and a relationship, and draws a simple two-table schema
Also known as: Selgitab andmebaasi tabelite ja seoste ülesehitust
Related knobits
Needed for
- K-517 Recognises an unstable or meaningful primary key
- K-518 Recognises an entity identified only by a system-assigned key
- K-911 Explains views in physical design
All knobits of Data modelling.
Source: Copy of k12 knobit K-69062 of the Estonian national curriculum register grok-l9-informaatika-1 (product k12-curriculum, skills/knobits/k12/grok-l9-informaatika-1.yaml), GRÕK lisa 9, Informaatika, Tarkvaraarendus, LO-69021; fingerprint translated from Estonian