ORIGINAL WORKED REFERENCE

The junction table has three rows: (1,10), (2,10) and (1,20). Grouping by event produces counts 2 and 1. A composite primary key prevents another (1,10), while foreign keys prevent a registration for a missing member. Neither rule alone checks remaining event capacity.

CRITICAL CONDITION
Foreign keys are enabled and invalid-insert evidence is retained; capacity enforcement is not falsely claimed.

LIMITS
This is a local schema exercise, not a concurrent booking service or a deployed database.

This reference is not a learner submission or proof of provider-course completion. See material-verification.json in the production package for actual preparation checks.
