Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the following data requirements and business rules, create an ER Model using Word , Excel, or hand drawn for PerfectFit Athletics ( PA

Based on the following data requirements and business rules, create an ER Model using Word , Excel, or hand drawn 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David Kroenke

11th Edition

0132302675, 9780132302678

More Books

Students also viewed these Databases questions

Question

What is Change Control and how does it operate?

Answered: 1 week ago

Question

How do Data Requirements relate to Functional Requirements?

Answered: 1 week ago