Stage 5: Derive the logical data model
Knobit of Data modelling · K-528 · Skill
Recognises one entity split by value into several
What it means
Entities with the same structure and meaning, differing only by a value that should be data: a year, a region, a product line. Every new value needs a model change, and every question across values needs a union. A specific form of row 27; the attribute form (Balance Q1 … Balance Q4) is row 4.
How it is assessed
Flags the deficient case and passes the acceptable one. Deficient: Payment 2025, Payment 2026; Account Tallinn, Account Tartu Acceptable: One Payment entity, the year derived from Payment Value Date; if volume needs a split, it is physical partitioning
Builds on
- Explains an entity type as the realisation of one business conceptK-570 · Knowledge