Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started