O cenário
A university comparison platform needs to store and compare universities by tuition fees and graduate employment outcomes across programs.
O que há neste desenho
Entenda as decisões por trás dele.
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.