Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees. Question Draw an E-R diagram for the system according to the above description.
Suppose you are asked to design a club
information. Each student has a unique student id, a name, and an email; each club
has a unique club id, a name, a contact telephone number, and has exactly
one student as its president. Each student can serve as a president in at most one of
the clubs, although he/she can be the members of several clubs. Clubs organize
activities and students can participate in any of them. Each activity is described by a
unique activity id, a place, a date, a time and those clubs that organize it. If an activity
is organized by more than one club, different clubs might contribute different
activity fees.
Question
Draw an E-R diagram for the system according to the above description.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
