Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3.IE Fitness company Conan wants to set-up a database for its members and trainers. One of the aims to record information about which members participated

image text in transcribed

3.IE Fitness company "Conan" wants to set-up a database for its members and trainers. One of the aims to record information about which members participated in which sessions and which trainers supervised which sessions Conan operates various fitness centers in various cities. Every center is characterized by a unique name (e.g., Fitplaza, my6pack). Every center has an address and one or more rooms (you can consider address as atomic). Every room has a maximum capacity. Within a center, each room has a unique number such as 1, 2, 3, etc People can register for individual or group sessions in different centers. Each group session requires exactly one trainer. Individual sessions are done without a trainer. For each person, we want to store the first name, family name, and birth date. You can assume that the combination of first name, family name, and birth date is unique. For each trainer, the diploma is also recorded A person can be a trainer in one session and participant in another session (either individualr group session). The model should also include information about people (e.g. prospects) that have not participated in any sessions yet, or trainers (e.g.. interns) that have not supervised any group sessions yet For each session, the date and starting hour should be recorded. For group sessions, also the type should be stored (e.g., aerobics, bodystyling, etc.). Sessions can start at the same time on the same day but in different rooms of a center or in different centers. At a given start hour of a given day, at most one individual or group session can start in a given room of a given center. Make an EER model and UML class diagram to model the data requirements for Conan Comment on the limitations of both models

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

New Trends In Databases And Information Systems Adbis 2019 Short Papers Workshops Bbigap Qauca Sembdm Simpda M2p Madeisd And Doctoral Consortium Bled Slovenia September 8 11 2019 Proceedings

Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Robert Wrembel ,Mirjana Ivanovic ,Johann Gamper ,Mikolaj Morzy ,Theodoros Tzouramanis ,Jerome Darmont

1st Edition

3030302776, 978-3030302771

More Books

Students also viewed these Databases questions

Question

What are some environmental disadvantages to plastic packaging?

Answered: 1 week ago

Question

What are the major global trends your industry faces?

Answered: 1 week ago

Question

What do you think of the MBO program developed by Drucker?

Answered: 1 week ago