The scenario
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.
What is in this drawing
Read the decisions behind it.
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.
More like this