This table stores information about gym members, including their unique Member ID, first name, last name, date of birth, gender, address, phone number, email, membership type (e.g., monthly, annual), join date, membership expiry date, and emergency contact details. The Trainers table holds data about fitness trainers, featuring a unique Trainer ID, first name, last name, date of birth, gender, contact details, specialization (e.g., personal training, group classes), years of experience, and any relevant certifications. In this table, you can find details about fitness classes offered by the gym. It includes a unique Class ID, class name, description, class schedule (days and timings), class capacity, the Trainer ID responsible for the class, and the class type (e.g., yoga, spin, HIIT). The Gym Equipment table keeps track of the various equipment available at the gym. It includes unique Equipment IDs, equipment names, descriptions, equipment conditions (e.g., new or used), purchase dates, and warranty expiration dates. This table records the workout details of gym members, such as the Member ID, Trainer ID, workout date, workout type (e.g., cardio, strength, flexibility), workout duration, calories burned, and any additional notes. The Nutrition Plans table contains details of nutrition plans provided to gym members. It includes a unique Plan ID, Member ID, start and end dates for the plan, plan descriptions, recommended meals, calorie intake, and any specific notes. This table tracks payment records made by gym members. It includes a Payment ID, Member ID, payment date, payment amount, payment method (e.g., credit card, cash), and payment status (e.g., paid, outstanding). The Attendance table records member attendance in gym classes. It captures the Attendance ID, Member ID, Class ID, attendance date, check-in time, and check-out time. Member reviews and feedback about trainers and classes are stored in this table. Each review has a unique Review ID and includes the Member ID, Trainer ID, Class ID, a rating, comments, and the review date. The Programs table lists the various fitness programs offered by the gym, including unique Program IDs, program names, descriptions, start and end times, Supervisor ID, and program types (e.g., morning, evening, day). This table contains information about the supervisors responsible for overseeing different gym programs. It includes Supervisor IDs, first names, last names, phone numbers, and email addresses for contact and coordination. Entity Relationship Diagram SEX SALARY SUPERVISOR FNAME FNAME ● ● NAME ● (1,1) SUPERVISED BY STAFF MINIT NAME MINIT (1,N) SCHEDULE DOB SUPERVISOR ID LNAME PROGRAMS PROGRAM TYPE SSN LNAME (0,N) STAFF ID PHONE d ADDRESS Assumptions: REGISTER FOR START TIME END TIME DAY PROGRAM ID (1,N) YEARS 10 TEACHER COMMUTER TYPE HOMEROOM TEACHER (1,1) VETERANS ELEMENTARY SCHOOL (0,1) TEAM LEAD OF (1,N) (1,1) BELONGS ΤΟ ROOM NO (1,N) STUDENT (N,M) ENROLLED IN (1,1) GRADE (1,N) (1,1) CONTAINS CLASSROOMS (1,N) TEACHES (1,1) SEX NAME FNAME (1,N) ROOM NO STUDENT ID ADDRESS MINIT GUARDIAN LNAME (1,1) SUPERVISES (1,N) COURSE ID GRADE_ID COURSES (1,N) (1,N) COURSE NAME GUARDIAN ID NAME PHONE# SCORE RECORD FNAME MINIT LNAME SUBJECT LEVEL REPORT_TYPE ********* Each Program needs at least one student. Each Guardian may have many students. Each Supervisor can supervise many Programs given that the programs are run on different day or time.