Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an EER diagram for school gyms using standard Chen's notation and following requirement Each fitness CENTER is identified by a CenterID, a name (e.g.

Draw an EER diagram for school gyms using standard Chen's notation and following requirement

Each fitness CENTER is identified by a CenterID, a name (e.g. XX Building) and campus. Every CENTER has one or more ROOMS that can be booked for sessions (either group or personal training). As in last time, rooms are noted by their maximum capacity. Within each center, the room number will be unique -- though this time, recognize that Room 116, for example, could exist in more than one center (Is this a strong or weak entity type?).

MEMBERS can sign up for personal or group sessions in different centers (but it is possible they won't sign up for any sessions). Each member has a member ID number.

Each SESSION (PERSONAL or GROUP) requires exactly one TRAINER. Even if there is another person co-teaching the class, the database will only store one official trainer of record for each class session. Sessions are identified by SessionID. A trainer is identified by his/her certification number. The system should accommodate trainers who are interns and may not have led any sessions yet.

For a session, the start time and room number will be recorded. For group sessions, the type should be recorded (i.e., aerobics, weight training, yoga, etc.). Sessions can start at the same time on the same day but in a different room of a center or in a different center. At a given start hour of a given day, at most one individual or group session may start in a given room of a given center.

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

Students also viewed these Databases questions

Question

Find dy/dx if x = te, y = 2t2 +1

Answered: 1 week ago