DATABASE DESIGN
Expo Judging Platform ERD
A worked database design example, rendered live. Open it in the AI editor and adapt it to your own case.
Make this diagram your own.
Open it in the AI editor with a prompt pre-filled — keep what works, change what doesn't.
CASE ANALYSIS
Scenario
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.
Key decisions
- Separated Student and Judge entities from generic User to allow distinct attributes and relationships.
- Modeled project-student and judging assignments as associative tables to resolve many-to-many relationships.
- Introduced ScoreDetail to capture per-criterion points, enabling detailed audit trails and weighted scoring.
When to reuse this
Use this schema as a baseline for K-12 science fairs, university expos, hackathons, or any multi-round judged event with rubric scoring.
Open this example in the editor →
Tweak it with chat, export PNG/SVG, or fork it for your own use case.
erd-expo-judging-platform-erd-final-version