シナリオ
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.