Question

Question 1 4 Marks A sports center aims to setup a database to maintain the following information. The database stores the name, the address and a unique ID of each employee. The employees are classified into three categories: trainers, receptionists and administrators. Each trainer has one or more specialties (eg, swimming, tennis and squash ete). Each receptionist can be reached through a landline phone number. Each receptionist must be supervised by one administrator and a administrator may supervise multiple receptionists. Each member of this sports center is identified by their membership id and the database also stores their names and emails. Each week a trainer may offer regular training classes that mernbers can participate in. Each training class should focus on one of the specialities of the corresponding trainer and must have a class size no more than 10. Each training class from a trainer is referred to by the day of the week (i.e., Monday, Tuesday, ...) because each trainer offers at most one training class per day. After a member participated in a training class, the rernber may submit feedback to a receptionist and the feedback contains a rating from 1 (very unsatisfied) to 5 (very satisfied), a date and detailed description. Your task is to design an Enhanced Entity Relationship (EER) diagram for the above database, which should include entities, relationships, attributes and constraints wherever appropriate (you can make more assumptions if necessary). You also need to identify the requirements that cannot be captured in an EER-diagram.

Answer 1

An entitiy diagram consist of three things:-

1)Entities:-Employee ,Trainer ,Administrator,Receptionist entity,Feedback entity,Training class ,Member entity

2)Attributes:- Attributes are Emp_ID ,address, name,Specialties,PhoneNo,rating , date , description, class_size , weekDay

3)Relationships :

1. There are IS A relationships between Employee entity ,Trainer entity , Administrator entity , Receptionist entity. Employee entity act as super entity and other are sub entity
2. There are Offer relationship between Trainer entity and Training class entity
3. There are Submit and Contains relationship between Receptionist entity , Feedback entity , Member entity
4. There are Supervised By relationship between Receptionist entity and Administrator entity
5. There are Participate relationship between Training class entity and Member entity.

Note:-The cardinality is being shown in the above diagram

Address ) Employee . Name TS А Specialties Trainee Receptionist M Administratos N phoneno date offer Feedback Submit M М. rating description Training aday Scontind IN M M Participate name Member memberid email

********************************************************************************************************************In case of any doubt do ask in the comment section.Hope you will like it