EDUCATION
Expo Judging Platform ERD
A worked education 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
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.
Key decisions
- Modeled team membership as a composite-key join table to support many-to-many relationships between students and teams.
- Linked scores to assignment and criterion rather than directly to judge and project to preserve assignment context and rubric structure.
- Included an expo foreign key on rubric so each event can define its own judging rubric.
When to reuse this
Reusable for hackathon, science fair, or any multi-event project judging system with rubric-based scoring and judge assignments.
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-judging-process