Reference no: EM133459684

Assignment:

Can you please help me to make ER Model for Best GYM.I need real diagram with the explanation.

BestGym plans to create a database system to manage their customers, locations, and classes. You, as a database designer, are invited to develop a data model using an ER Model. Based on the following data requirements and business rules, draw an ER Model for BestGym.

Most importantly, the database needs to store member information (such as member ID, first name, last name, phone number, address, and membership expiration date). An employee assists one or more members. Each member is assisted by one employee. Information on employees needs to be stored (such as employee ID, first name, last name, address, phone number, and hire date).

An employee is assigned to one or more locations. Each location is assigned many employees.

For each location, they need to know location ID, address, phone number and business hours. Additionally, each employee's number of hours assigned to a location should be stored. Each location is managed by a manager. A manager manages one location.

Each location opens one or more classes (e.g., yoga, spinning ...). Information on a class (such as class ID, class name, hours and maximum number of people) needs to be stored. A member signs up one or more classes and each class is signed up by one or members. They want to store sign-up dates and times.