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 eg 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
