The scenario
A wedding hall business needs to manage customer bookings, assign staff and halls, select packages, and track payments.
What is in this drawing
Read the decisions behind it.
01
Model booking as central entity linking customer, hall, package, and staff
02
Separate payment entity for financial tracking
03
Use many-to-one relationships from booking to lookup entities
Use when designing a relational schema for event or booking management systems with lookups and financial records.
More like this