シナリオ
A science fair or expo platform needs to register projects by category, assign judges to projects across rounds, collect rubric-based scores, and track winners.
この図に含まれるもの
図の背後にある意思決定を読み解く。
01
Separated Student and Judge entities from generic User to allow distinct attributes and relationships.
02
Modeled project-student and judging assignments as associative tables to resolve many-to-many relationships.
03
Introduced ScoreDetail to capture per-criterion points, enabling detailed audit trails and weighted scoring.
Use this schema as a baseline for K-12 science fairs, university expos, hackathons, or any multi-round judged event with rubric scoring.