情境
Design an ER diagram for a wedding hall management system that tracks customers, hall reservations, add-on services, invoices, and payments.
這張圖裡有什麼
看懂背後的決策。
01
Used a composite-key junction table BookingService to model many-to-many bookings and services
02
Separated Invoice and Payment to support partial payments and due tracking
03
Kept Hall as a distinct entity with capacity and pricing attributes
Use for systems needing reservation, add-on service, and billing workflows for venue or event management.