The scenario
An expo judging platform must track expos, categories, projects, teams, judges, assignments, scores, awards, and winners.
What is in this drawing
Read the decisions behind it.
01
Surrogate keys for assignments and scores simplify references while preserving judge-project links.
02
Winner entity links Awards to Projects and supports multiple ranks per award.
Use when modeling multi-category expos where judges score projects and organizers assign awards to winning projects.
More like this