Das Szenario
Design the database behind a university comparison platform that stores institutional profiles, ranking results by metric, and student satisfaction survey responses.
Was diese Zeichnung zeigt
Die dahinterstehenden Entscheidungen verstehen.
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.