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, 23.06.2019 11:30
In cell h5 enter a formula that will calculate the percentage of attendees that went to the altamonte springs job fair in 2018.
Answers: 1
question
Computers and Technology, 23.06.2019 21:40
language consists of basic components, and they are called a. 3; mental images, concepts, and speech b. 2; language acquisition and linguistic relativity c. 3; heuristics, algorithms, and analogies d. 4; phonemes, morphemes, syntax, and semantics e. 2; words and grammar
Answers: 3
question
Computers and Technology, 24.06.2019 04:30
Fall protection, confined space entry procedures, controlled noise levels, and protection from chemical hazards are some of the things that contribute to a safe and
Answers: 1
question
Computers and Technology, 24.06.2019 09:10
  to change the number of rows and columns displayed by the excel object a. select the object and drag a size handle on the active object. b. deselect the object and drag a size handle of the object. c. deselect the object and drag a row or column divider of the object. d. select the object and drag a row or column divider on the active object.
Answers: 2
You know the right answer?
A fitness club offers many classes, each of which has attributes (ClassID, ClassDesc, ClassSchedule)...
Questions
question
Mathematics, 07.07.2021 18:50
question
Chemistry, 07.07.2021 18:50
question
Mathematics, 07.07.2021 18:50
question
Chemistry, 07.07.2021 18:50
question
Mathematics, 07.07.2021 18:50
Questions on the website: 13722363