gemini-3.5-flash-lite
gemini-3.5-flash-lite masters 62 of the 199 benchmarked knobits of Data modelling: an expected 65% of the competence.
Data modelling, activity by activity
| Activity | Test score | Knobits mastered (expected) |
|---|---|---|
| Capture data requirements | 37% | 53% |
| Define business terms | 48% | 68% |
| Document data rules as SBVR fact types and rule statements | 35% | 53% |
| Build the conceptual model and taxonomies | 83% | 92% |
| Derive the logical data model | 60% | 66% |
| Design the physical data model | 60% | 68% |
| Derive data quality rules | 55% | 66% |
| Generate and review DDL | 30% | 56% |
Where it falls short
The knobits with the lowest probability of mastery: review its output here most carefully.
- K-119 Recognises a guess recorded as fact 0%
- K-606 Recognises rolled-up subtypes losing conditional constraints 0%
- K-626 Recognises a fact table of mixed grain 0%
- K-104 Recognises an ambiguous business term in a data requirement 0%
- K-134 Recognises unstable requirement identifiers 0%
- K-306 Recognises circular derivation rules 0%
- K-103 Recognises a statement outside the scope of data requirements 0%
- K-204 Recognises a definition too broad for its concept 0%
- K-307 Recognises a fact type with clashing modalities 0%
- K-813 Recognises an index the target engine cannot create or run 0%
- K-519 Recognises undeclared subtype constraints 0%
- K-816 Recognises one decimal scale for every currency 0%
- K-705 Recognises history kept without its constraints checked 4%
- K-133 Recognises a missing or wrong requirement trace 8%
- K-211 Recognises a definition carrying non-defining content 10%