Das Szenario
A university comparison platform needs to store and compare universities by tuition fees and graduate employment outcomes across programs.
Was diese Zeichnung zeigt
Die dahinterstehenden Entscheidungen verstehen.
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.