상황
Design the database schema for a science and engineering expo judging platform where student teams submit projects, judges are assigned to review them, and scores are recorded against rubric criteria.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Modeled team membership as a composite-key join table to support many-to-many relationships between students and teams.
02
Linked scores to assignment and criterion rather than directly to judge and project to preserve assignment context and rubric structure.
03
Included an expo foreign key on rubric so each event can define its own judging rubric.
Reusable for hackathon, science fair, or any multi-event project judging system with rubric-based scoring and judge assignments.