シナリオ
A comparison platform allows prospective students to evaluate university programs by tuition, living costs, median salaries, employment rates, and calculated ROI.
この図に含まれるもの
図の背後にある意思決定を読み解く。
01
Normalized CostData, EarningsData, and ROI as separate entities to support historical and multi-year comparisons.
02
Introduced User, Comparison, and ComparisonItem to support saved multi-program side-by-side comparisons.
03
Used composite primary keys on ComparisonItem to enforce unique program entries within each comparison.
Reuse this schema for any web application that aggregates institutional cost and outcome data for comparative analysis.