The scenario
A 24/7 fitness club needs a database to manage members, membership plans, class schedules, bookings, instructors, and payments. This ER diagram models the core entities and relationships.
What is in this drawing
Read the decisions behind it.
01
Separate MembershipPlan from Member to track plan details independently
02
Booking links Member and Class with status and date
03
Payment relates to Member and optionally to Booking for flexible billing
Suitable for gym management systems, sports club scheduling, and any membership-based booking platform.
More like this