Draw an ER diagram for the above problem using your analytical skills. Your ER diagram must include entities, attributes, relationships, cardinality, and multiplicity.

1.  
2. GYM DATABASE MANAGEMENT SYSTEM
3.  
4. In this project, you are asked to build a database for Gym Management System, that is used to keep track of customer registration and class booking serviceGym is one of the leading chains of boutique fitness centers for women in Saudi Arabia. They bring you certified trainers, world-class equipment, full-service facilities, innovative classes and beautiful studios to inspire you on your personalized path towards health and fitness. It offers up to 60 group exercise classes per week included in the standard membership, smaller specialty classes for a fee, and one one-on-one personal training sessions so you can mix and match in accordance with your health and fitness goals. The Gym also has a system that contains detailed records of members and their membership information with providing booking classes services.
5.  
6. A customer can access any branch by visiting the branch and asking the receptionist to join a membership by providing his/her information. The gym offers a variety types of membership (Standard, Gold, Student and Corporate) that members can choose one of them for specific period (1month, 3monthes, 6monthes, 12 months or 18 months).
7.  
8. After registration, trainee with Gold membership can access any branch but members with other types can only access the branch they registered with. There are many branches in different cities, with different locations and working day. Each branch offers many facilities to customers (swimming pool, spa pool, shower rooms , sauna, steam rooms etc..) each with specific quantities. Additionally, each branch offers several special equipment (elliptical, exercise balls, Stationary Bicycle, Treadmills, etc..)
9.  
10. Trainee can ask the receptionist to book up to four different classes a day. If the desired class is available, the receptionist will book it. Each class is held in a specific studio (Studio 1, Studio 2, Spinning Studio), and it is given by a certain trainer.
11.  
12. The Gym keeps information about members, membership, classes, trainers, studios, equipment, facilities...etc.

Answer rating: 100% (QA)

name Members 315 email phone Access address name Id working day ... View the full answer