The scenario
A fitness center needs to track members, their subscription plans, class schedules, instructors, and member bookings for classes.
What is in this drawing
Read the decisions behind it.
01
Used separate MembershipPlan table for subscription management
02
Normalized Booking table to link members and classes with status
03
Instructor assigned to each class for scheduling
Use this schema as a starting point for a gym, yoga studio, or any fitness facility needing member and class management with booking capabilities.
More like this