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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 23.06.2019 23:00, GreenHerbz206
Computer programming is one type of what career
Answers: 1
image
Computers and Technology, 24.06.2019 00:20, talyku843
Describe a data structures that supports the stack push and pop operations and a third operation findmin, which returns the smallest element in the data structure, all in o(1) worst-case time.
Answers: 2
image
Computers and Technology, 24.06.2019 02:20, Jonny13Diaz
The first time a user launches the powerpoint program, which view is shown allowing the user to access recent presentations or create new presentations based on templates?
Answers: 1
image
Computers and Technology, 24.06.2019 03:00, firenation18
Click the "draw structure" button to activate the drawing utility. draw two diastereomers of (1z,4r)−1,4−dimethylcyclodecene and name them, including (e)/(z) and (r)/(s) notation. part 1 out of 4 draw the diastereomer containing a chiral center with s configuration here. window open
Answers: 1
You know the right answer?
A fitness club offers many classes, each of which has attributes (ClassID, ClassDesc, ClassSchedule)...

Questions in other subjects:

Konu
Mathematics, 04.04.2021 06:00
Konu
Mathematics, 04.04.2021 06:00