subject

A fitness club offers many classes, each of which has attributes (ClassID, ClassDesc, ClassSchedule). The ClassSchedule is a composite attribute consisting of (ClassDate, ClassTime). Each class is taught by one instructor who has attributes (InsID, InsName). One instructor can teach multiple classes while each class is taught by only one instructor. Some instructor may have never taught any class yet. The club also records information about its members, each of which has attributes (MemberID, MemberName, MemberAddress). A class should have at least one members attending it. Some members do not attend any class while some may attend multiple classes. Do the following: 1) Draw an Entity-Relationship diagram (ERD) for the above situation. Choose identifiers as appropriate. You should clearly represent the entity type names, relationship names, attributes, identifiers, cardinality constraints, etc. in you ERD.
2) Assume that a member can leave a feedback for a class she attended or is attending (it is optional). Introduce an associative entity type to model feedback and redraw the ERD. You only need to redraw the part about customer, class, and feedback.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 10:20
Print "usernum1 is negative." if usernum1 is less than 0. end with newline. convert usernum2 to 0 if usernum2 is greater than 10. otherwise, print "usernum2 is less than or equal to 10.". end with newline
Answers: 3
question
Computers and Technology, 23.06.2019 04:00
Laire writes a letter to her grandmother, in which she describes an amusement park she visited last week. she adds pictures of that place in her letter. which feature of a word processing program will claire to remove unwanted parts of the pictures?
Answers: 3
question
Computers and Technology, 23.06.2019 20:30
1. for which of the following are you not required to signal beforehand? a. changing lanes b. speeding up c. stopping
Answers: 2
question
Computers and Technology, 23.06.2019 21:00
Which task uses a simple parameter?
Answers: 1
You know the right answer?
A fitness club offers many classes, each of which has attributes (ClassID, ClassDesc, ClassSchedule)...
Questions
question
Mathematics, 30.10.2020 03:20
question
Mathematics, 30.10.2020 03:20
question
Mathematics, 30.10.2020 03:20
question
Mathematics, 30.10.2020 03:20
question
Health, 30.10.2020 03:20
Questions on the website: 13722360