The scenario
A wedding hall business needs a relational schema to manage customers, halls, bookings, event details, payments, optional services, and staff assignments.
What is in this drawing
Read the decisions behind it.
01
Separate Booking from Event to allow multiple event segments per reservation.
02
Model many-to-many service selections via BookingService.
03
Use Payment linked to Booking for installment tracking.
Reuse for wedding venue, banquet hall, or event rental booking systems with service add-ons and staff scheduling.
More like this