Recognises one entity split by value into several

K-528 · Skill knobit · Activity: Derive the logical data model · Competence: Data modelling

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.

Can AI do this?

Not tested yet

No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.

What it looks like in practice

Expected result: The entities and the value that should be an attribute

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

Also known as: One entity split by value (logical model)

Related knobits

Builds on

• K-570 Explains an entity type as the realisation of one business concept

Needed for

• K-605 Recognises an entity split into clone tables by value

All 56 knobits of Derive the logical data model.

Source: Review checklist 05-logical, row 28; Karwin, Metadata Tribbles; Date & McGoveran 1994