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