情境
A university comparison platform needs to store and compare universities by tuition fees and graduate employment outcomes across programs.
這張圖裡有什麼
看懂背後的決策。
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.