Lo scenario
Design the database behind a university comparison platform that stores institutional profiles, ranking results by metric, and student satisfaction survey responses.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
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.