情境
Design the database behind a university comparison platform that stores institutional profiles, ranking results by metric, and student satisfaction survey responses.
這張圖裡有什麼
看懂背後的決策。
01
Use a RankingMetric table to normalize different ranking criteria and sources.
02
Model UniversityRanking as a fact table with foreign keys to University and RankingMetric.
03
Separate StudentSatisfactionSurvey and SurveyResponse tables to track multiple responses per survey.
When building a platform that compares universities using multiple ranking sources and aggregates student feedback.