The scenario
The university comparison platform needs an ER model that links tuition, aid, graduate outcomes, alumni employment, and employer industries to evaluate institutional value-for-money and network impact.
What is in this drawing
Read the decisions behind it.
01
Separate CostSnapshot per program and year to track changing tuition
02
AlumniEmployment as an associative entity between Alumni and Employer to expose professional network reach
03
GraduateOutcome and RankingMetric capture measurable return and reputation signals
Use this schema when building a data store for comparing universities on financial value and alumni career network strength.
More like this