상황
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.