Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Maria is starting a small gym and fitness centre named FitLife. She wants to organize her gym's operations and member information effectively. FitLife needs to
Maria is starting a small gym and fitness centre named "FitLife." She wants to organize her gym's operations and member information effectively. FitLife needs to manage information about its members, trainers, classes, and membership plans. In this task, you are invited to design a database for Maria. FitLife needs to store member details such as Member ID, name, email, date of birth (DOB), and phone number. Additionally, FitLife needs to keep track of the trainers it employs, including Trainer ID, name, date of birth (DOB), mobile number, and specialization. Moreover, Maria wants to track information about the fitness classes offered at FitLife, which includes Class ID, class name, description, and schedule. Each class is conducted by a group of two trainers to ensure the quality of instruction and coverage of various fitness aspects. To enroll in classes and use the gym facilities, members need to subscribe to membership plans. Membership plans have different levels: Platinum, Gold, and Silver. Each membership level has associated perks and fees. Platinum membership charges $1000 per annum, Gold membership charges $750 per annum, and Silver membership charges $500 per annum. Maria also wants to track attendance for each class to monitor member engagement and satisfaction
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started