Question: Based on the following data requirements and business rules, create an ER Model for PerfectFit Athletics ( PA ) . PA operates multiple locations in

Based on the following data requirements and business rules, create an ER Model for PerfectFit Athletics (PA).
PA operates multiple locations in Central Arkansas. PA offers a variety of classes (e.g., yoga, spinning, swimming ...) for their members. Member information (such as member ID, first name, last name, phone number, address, membership start date and membership expiration date) are maintained in the system.
Each member is assisted by an employee. An employee assists one or more members. Employee information (including employee ID, first name, last name, address and phone number) is stored. There are two types of employees: coach and administrative staff. For a coach, additional information (such as coaching event, fee and certification) is stored. For administrative staff, job title is additionally stored. Each employee has a supervisor. A supervisor supervises more than one employee.
A class has one or more sections. Each section is always associated with a class. Attributes of a class include class ID, class name and class points. Attributes of a section include class ID, section ID, type and maximum number of attendees. A member signs up for one or more sections and each section is signed up by one or more members. They want to store the member sign-up date and time for each section.
Each employee is assigned to a one location. A location is assigned many employees. For each location, they need to know location ID, address, phone number and business hours.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!