Lo scenario
A university comparison platform needs to store and compare universities by tuition fees and graduate employment outcomes across programs.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
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.