Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an ER model using the UML notation for the following problem description. Fitness company MyHealth will open a new fitness center in Philadelphia. MyHealth

Create an ER model using the UML notation for the following problem description.

Fitness company MyHealth will open a new fitness center in Philadelphia. MyHealth wants to setup a database for its members, trainers, and sessions. One of the aims is to record information about members, sessions, and trainers. The system will not record any equipment or actual membership payments for simplicity.

The center has an address and one or more training rooms. Within the center, each room has a unique number such as 1, 2, 3, Every room also has a maximum capacity and a room type. MyHealth will record member#, first name, last name, address, and cell phone number.

The center has multiple group sessions (e.g., Yoga, Pilates, Body styling, etc). Each group session requires exactly 1 group trainer and done in a specific room in the center. A group session may be held once a week, twice per week or three time per week at different time (but always in the same room). So, the center needs to record the day of the week, starting time, and ending time of each group session. Members must register for a group session because there is a maximum in each group session and the center wants to know which group sessions are popular by how many people.

A member can also sign up for private training with exactly one personal trainer. That is, there are two types of trainers in the center. One is a group session trainer and another is private trainer who gives a private training to the person who signs up for a private training. Members do not pay extra for group sessions, but they need to pay an extra fee to register for private training. For each private training, the extra fee will be determined differently by each personal trainers level and #sessions signed. The trainer keeps track of all the private training sessions of each signed member including begin time, end time and a brief comment on what training was done during each session to give a best training experience to the member. For each trainer, his/her diploma is also recorded. A trainer can be a group session trainer or a private training session trainer or both.

Model all the requirements mentioned above. For any unstated requirements, you can make your own assumption, but clearly state them.

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

More Books

Students also viewed these Databases questions