Analytics and Reporting $($my part$)$

Aits about analyzing member demographics, attendance trends, and satisfaction surveys.

Optimizing class schedules, staffing levels, and marketing strategies based on data insights. it is required to Use MySQL to create the required statements $($create tables with attributes, insert for the tuples, retrieve$)$ for Gym and fitness centre management system. I will send my answer check it$,$ if its not correct fix it please.

CREATE TABLE MemberDemographics $($

member$\_$id INT PRIMARY KEY,

age INT,

gender ENUM$(\text{'}$Male$\text{'},$ 'Female', 'Other'$),$

location VARCHAR$(100),$

occupation VARCHAR$(100),$

income DECIMAL$(10,2),$

join$\_$date DATE,

FOREIGN KEY $($member$\_$id$)$ REFERENCES Members$($member$\_$id$)$

$)$;

CREATE TABLE AttendanceTrends $($

date DATE PRIMARY KEY,

total$\_$attendance INT,

UNIQUE KEY $($date$)$

$)$;

CREATE TABLE SatisfactionSurveys $($

survey$\_$id INT AUTO$\_$INCREMENT PRIMARY KEY,

member$\_$id INT,

satisfaction$\_$rating INT,

comments TEXT,

survey$\_$date DATE,

FOREIGN KEY $($member$\_$id$)$ REFERENCES Members$($member$\_$id$)$

$)$;

CREATE TABLE ClassSchedules $($

class$\_$id INT AUTO$\_$INCREMENT PRIMARY KEY,

class$\_$name VARCHAR$(100),$

instructor$\_$name VARCHAR$(100),$

class$\_$schedule DATETIME,

max$\_$capacity INT,

UNIQUE KEY $($class$\_$schedule$)$

$)$;

CREATE TABLE StaffingLevels $($

date DATE PRIMARY KEY,

total$\_$staff INT,

UNIQUE KEY $($date$)$

$)$;

CREATE TABLE MarketingStrategies $($

strategy$\_$id INT AUTO$\_$INCREMENT PRIMARY KEY,

strategy$\_$name VARCHAR$(100),$

description TEXT,

start$\_$date DATE,

end$\_$date DATE

$)$;

INSERT INTO MemberDemographics $($member$\_$id$,$ age, gender, location, occupation, income, join$\_$date$)$ VALUES $(1,30,$ 'Male', 'New York', 'Software Engineer', $80000\mathrm{.}00,\text{'}2023-01-10\text{'}),(2,35,$ 'Female', 'Los Angeles', 'Marketing Manager', $75000\mathrm{.}00,\text{'}2022-12-05\text{'}),(3,25,$ 'Male', 'Chicago', 'Student', $20000\mathrm{.}00,\text{'}2024-02-20\text{'})$;

INSERT INTO AttendanceTrends $($date$,$ total$\_$attendance$)$

VALUES

$(\text{'}2024-04-01\text{'},150),$

$(\text{'}2024-04-02\text{'},160),$

$(\text{'}2024-04-03\text{'},170)$;

INSERT INTO SatisfactionSurveys $($member$\_$id$,$ satisfaction$\_$rating, comments, survey$\_$date$)$

VALUES

$(1,4,$ 'Great facilities and friendly staff.$\text{'},\text{'}2024-04-12\text{'}),$

$(2,5,$ 'Love the variety of classes offered.$\text{'},\text{'}2024-04-12\text{'}),$

$(3,3,$ 'Could improve cleanliness in the locker rooms.$\text{'},\text{'}2024-04-12\text{'})$;

INSERT INTO ClassSchedules $($class$\_$name, instructor$\_$name, class$\_$schedule, max$\_$capacity$)$

VALUES

$(\text{'}$Yoga$\text{'},$ 'Sarah Jones', $\text{'}2024-04-1210$:$00$:$00\text{'},20),$

$(\text{'}$Spin$\text{'},$ 'Michael Smith', $\text{'}2024-04-1212$:$00$:$00\text{'},15),$

$(\text{'}$Zumba$\text{'},$ 'Emily Brown', $\text{'}2024-04-1216$:$00$:$00\text{'},25)$;

INSERT INTO StaffingLevels $($date$,$ total$\_$staff$)$

VALUES

$(\text{'}2024-04-01\text{'},10),$

$(\text{'}2024-04-02\text{'},12),$

$(\text{'}2024-04-03\text{'},11)$;

INSERT INTO MarketingStrategies $($strategy$\_$name, description, start$\_$date, end$\_$date$)$

VALUES

$(\text{'}$Social Media Campaign', 'Launch a targeted ad campaign on Facebook and Instagram.$\text{'},\text{'}2024-04-01\text{'},\text{'}2024-05-01\text{'}),$

$(\text{'}$Referral Program', 'Offer discounts to members who refer new customers.$\text{'},\text{'}2024-04-01\text{'},\text{'}2024-06-01\text{'})$;

SELECT $*$ FROM MemberDemographics WHERE member$\_$id $=1$;

SELECT $*$ FROM AttendanceTrends WHERE date BETWEEN $\text{'}2024-04-01\text{'}$ AND $\text{'}2024-04-03\text{'}$;

SELECT $*$ FROM SatisfactionSurveys WHERE survey$\_$date $=\text{'}2024-04-12\text{'}$;

SELECT $*$ FROM ClassSchedules WHERE class$\_$name $=$ 'Yoga';

SELECT $*$ FROM StaffingLevels WHERE date $=\text{'}2024-04-01\text{'}$;

SELECT $*$ FROM MarketingStrategies WHERE start$\_$date CURDATE$()$ AND end$\_$date $>=$ CURDATE$()$;