상황
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.