Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Thermodynamics For Engineers

Authors: Kenneth KroosMerle PotterMerle Potter, Merle PotterDavid Bergin

1st Edition

1305143051, 9781305143050

More Books

Students also viewed these General Management questions