Question: Construct an ER diagram for a simple database that records the many clubs at Iowa State University. Each club has a unique name and a

Construct an ER diagram for a simple database that records the many clubs at Iowa State University.
Each club has a unique name and a description of the club (e.g., soccer, table tennis).
The database needs to store the current members of each club. A club can have many members (who must be students), and one and only one president (who must be a student).
For each student, record their ISU ID, name, major, and when they join a specific club. A student can join many clubs as a member. A student can also be the president of one club and a member of other clubs at the same time but can be president of at most one club.
draw a diagram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!