A database is needed for a fitness center to keep information about its operations. The database keeps

all information about personal $($members$,$ trainers, and staff$),$ payment history, workout & workout

plan; and schedule of workout.

$$ There are fitness trainers who serve as the trainer and prepare the different workout plan. Their

information in the system include: trainer$-$id$,$ name $($first name and last name$),$ address, email, and

two phone numbers.

$$ A customer needs to register to become a member of the fitness center and can access the facilities

available in the fitness center. The database keeps members$$ information such as member$-$id$,$ name

$($first name and last name$),$ address, phone number, email, DOB, age, gender, the date of

membership, the expiration date of membership, and user$-$id $($the staff who processed the

registration$).$

$$ The fitness center offers different types of membership with corresponding amount and expiration

date. The database keeps all info of type$-$id$,$ type$-$name, membership$-$period, membership$-$amount,

signup$-$fee, and use$-$id$.$

$$ The fitness center has multiple staff working at different time. The staff can access the system and

allowed to process transactions. Their information stored in the fitness database is user$-$id$,$ name

$($first name, and last name$),$ phone number, emails, address, username, and password.

$$ The database table stores the payment of customers upon the registration and membership. The

payment info includes payment$-$id$,$ member$-$id$,$ amount, payment$-$time, payment$-$date, and user$-$id$.$

$$ The database also has the workout info such as workout$-$id$,$ workout$-$name, and description.

$$ The members are allowed to select different types of workout that they want. So the workout plan

tables have these info: plan$-$id$,$ member$-$id$,$ workout$-$id$,$ workout$-$date, workout$-$time, and trainer$-$id$.$

Note: The center has several trainers, and a member may be trained by different trainers on different

meeting. When a member makes a visit at an appointed time, the name of the trainer, the workout

plan, the date and time are recorded for that visit.