情境
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.