The scenario
A university comparison platform needs to store and compare universities by tuition fees and graduate employment outcomes across programs.
What is in this drawing
Read the decisions behind it.
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.
More like this