Question: please show image Based on the following data requirements and business rules, create an ER Model for BestFit Gym ( BG ) . BG has
please show image
Based on the following data requirements and business rules, create an ER Model for BestFit Gym BG
BG has multiple locations in Little Rock. Each location opens many classes such as yoga and spinning Each class is opened at more than one location. Information on a class such as ClassID, ClassName, Hours and MaximumNumber needs to be stored. For each location, they need to know LocationID, Address, PhoneNumber and BusinessHours. In addition, they want to store the date and time for each class. The dates and times are varying at the different locations.
A member signs up one or more classes and each class has more than one member. They want to maintain information on members such as MemberID, FirstName, LastName, PhoneNumber, Address, and MembershipExpirationDate Additionally, they want to store the signup dates and times.
An employee assists one or more members. Each member is assisted by one employee. Information on employees needs to be stored including EmpID, FirstName, LastName, Address, PhoenNumber, and HireDate Each employee has a supervisor. A supervisor manages more than one employee. There is a manager for each location. Each location is managed by a manager. A manager manages only one location.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
