El escenario
A university comparison platform needs to store and compare universities by tuition fees and graduate employment outcomes across programs.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
01
Separate TuitionFee and EmploymentOutcome tables linked to Program to support multi-year tuition and outcome records
02
Use ComparisonItem composite table to represent many-to-many saved comparisons between users and universities
03
Assign UK to University.website and User.email to enforce uniqueness
Reusable for any platform that compares higher-education institutions by cost and employment metrics.