Use ER diagram

PROJECT DESCRIPTION

In Jordan there are more than 1,200 registered gyms that are providing different fitness services for customers. Gyms are becoming popular worldwide , and may investors are investing their money in this business. However, it is noticeable that many gyms are not having database for managing the customers, employees and activities. In this project you need to create an ER Diagram for those gyms in order to facilitate working with the needed data.

The Gym application database will have the following users information:

• CUSTOMERS
• Manager
• Trainer
• Worker

CUSTOMERS

• Customers will have the following attributes associated with them , custid , name and it has 3 components that are (first, Middle, Last) , address, sex, DOB that is date of birth, Age and phone that can have multiple numbers
• Customer can register for the Gym, and the Gym has Gym id (GID), Name, Address, Telphone (Tel) that can have multiple phone numbers. Each customer can register in one Gym, and the Gym can have multiple Customers. When the customer registers to the Gym a registration date (REG_DATE) will be saved to the system.
• Customer can access different types of facilities, such as (Indoor, outdoor, swimming pool, Sauna, Jacuzzietc), each facility will have facility number (FID), Name, Type that can be (Indoor, outdoor, swimming pool, Sauna, Jacuzzietc) , Description of each facility.
• Customer can access different Classes available and each class has class id (CID) , Name, Type (which can be of different types) and Time for the class.

MANAGER

• Manager will manage the entire Gym and each Gym will have one manager only.
• Manager will manage the Trainer, Worker
• Manager would be responsible for creating Classes
• Manager will have id, name and multiple Telephone numbers

TRAINER

• will have id and name.
• Trainer will run the many Classes and each class will have one trainer
• Trainer will be registered with their Gym and each gym can have multiple trainers

Workers

• Workers will be responsible for cleaning the Facilities, and they can clean multiple facilities and each facility can have multiple workers.
• Workers have Id and name.

Additional ASSUMPTIONS

• One Facility can be used by multiple Customers in the Gym
• One Worker Clean one facility and each facility can have more than one woker
• Manager manages many workers and trainers, and each worker or trainer is manage by one manager.

A Customer can attend many classes and each class can have many customers.