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 14:10
Dean wants a quick way to look up staff members by their staff id. in cell q3, nest the existing vlookup function in an iferror function. if the vlookup function returns an error result, the text “invalid staff id” should be displayed by the formula. (hint: you can test that this formula is working by changing the value in cell q2 to 0, but remember to set the value of cell q2 back to 1036 when the testing is complete.)
Answers: 3
question
Computers and Technology, 23.06.2019 17:00
The more powerful, 60 volt cables and the main power shut off on an hev are both colored orange
Answers: 1
question
Computers and Technology, 23.06.2019 19:30
What are loans to a company or government for a set amount of time
Answers: 1
question
Computers and Technology, 24.06.2019 17:30
Looking at the electroscope, describe how you can cause the two leaves at the bottom to repel each other and stay that way
Answers: 3
You know the right answer?
A fitness club offers many classes, each of which has attributes (ClassID, ClassDesc, ClassSchedule)...
Questions
question
History, 28.11.2019 13:31
question
Mathematics, 28.11.2019 13:31
Questions on the website: 13722367