gemini-3.8-flash
gemini-3.8-flash masters 143 of the 199 benchmarked knobits of Data modelling: an expected 88% of the competence.
Data modelling, activity by activity
| Activity | Test score | Knobits mastered (expected) |
|---|---|---|
| Capture data requirements | 70% | 67% |
| Define business terms | 85% | 94% |
| Document data rules as SBVR fact types and rule statements | 82% | 93% |
| Build the conceptual model and taxonomies | 93% | 100% |
| Derive the logical data model | 69% | 94% |
| Design the physical data model | 86% | 92% |
| Derive data quality rules | 81% | 94% |
| Generate and review DDL | 61% | 66% |
Where it falls short
The knobits with the lowest probability of mastery: review its output here most carefully.
- K-606 Recognises rolled-up subtypes losing conditional constraints 0%
- K-816 Recognises one decimal scale for every currency 0%
- K-309 Recognises a gap in a partition of cases 0%
- K-211 Recognises a definition carrying non-defining content 9%
- K-103 Recognises a statement outside the scope of data requirements 10%
- K-828 Recognises a business date stored with a time of day 14%
- K-718 Recognises a misfiled data quality dimension 20%
- K-821 Recognises a restricted column without access design 20%
- K-117 Recognises a missing or wrong requirement type 21%
- K-810 Recognises a truncated identifier taken as the real name 22%
- K-822 Recognises greenfield DDL aimed at a populated database 25%
- K-823 Recognises a drop script used as a rollback 25%
- K-817 Recognises a length taken from sample data 28%
- K-132 Recognises a requirements register serving no stated question 32%
- K-127 Recognises an uncovered identity requirement 34%