Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help provide full details. TotalFit is a health club that offers a number of exercise classes to its members. You are hired to design

please help provide full details.
image text in transcribed
TotalFit is a health club that offers a number of exercise classes to its members. You are hired to design a database system for the company. An initial analysis produced the following facts: - Each member is identified by a unique member identifier, has a name, an address, and a registration date is recorded when a member registered. - The club offers several types of memberships: student, VIP, senior, ordinary, and family. The fees are different for each type. A member can participate in several exercises but has to register for each exercise class. The type of exercises can be cardio, weightlifting, yoga, gym etc. For each exercise type, there can be several exercises scheduled. - Each exercise class is assigned an instructor and is taught in a specific room on a specified date and a specific time (given as start time and duration). -Each exercise has an identifier, a name, and a description. - Each room is identified by a building name and a room number. - Each instructor teaches at least one class. -Some instructors are employees of the club and are salaried. The club also uses the service of external instructors for which it keeps track of the number of hours taught and the wage per hour. Questions - Give an entity-relationship diagram for the NJIT Fitness Club. Indicate the cardinalities of the relationships, the keys of the entity types, and any weak entity types (in other words, give a full ER model diagram.) State explicitly any additional assumptions that you may make and feel free to add additional attributes if you wish. -Give a step-by-step mapping (explain your decisions)

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

Question

1. Identify and control your anxieties

Answered: 1 week ago