The Modeling Room: (M2) Describe the people & things - (A9) Model hierarchies
Series: The Modeling Room, module 2, part 9 of 26. Build a part-to-group hierarchy with the bike-shop team. Trace three fittings into grouped results, expose a second-parent error, and keep missing categories visible without losing recorded work or money.
Who should read it?
Students learning modelstorming, analysts, report builders, data modelers working with business experts
Prerequisite
Distinguish a member's identity from its labels and stored row keys, as in article 8.
Learning objective
Agree a simple grouping hierarchy and test whether it preserves the selected occurrence count and charge.
Artifact
A two-level hierarchy card with member-to-parent examples, relationship and totals tests, and named open checks.
What you'll learn
- How to agree a simple detail-to-parent grouping path and test both directions.
- How to trace every selected occurrence into a grouped result and challenge the path.
Your output: one hierarchy card with mapping, checks, a rejected alternative, and named open checks.
New terms: hierarchy and rollup.