Question: Your university needs a database to track information about student clubs. It will need to track student ( club members ) information such as Student

Your university needs a database to track information about student clubs. It will need to track student (club members) information such as Student ID, name, major, and email address. It will also need to track club information such as club name (unique), date founded, description of the purpose of the club, faculty advisor name, and the club type (such as sports, gaming, art, performing, dancing).Furthermore, it needs information of the club membership - which students are or were members of a certain club. A student may apply to join any club at any time, and they may leave a club at any time (which means their membership ends). To track if a membership is current, that is, if a particular student is currently a member of a club, the start date and end date of membership will be needed. A student can be a member of multiple clubs at the same time, and they may choose not to join any club. A club does not exist without having at least one member. A club may have many members.A club will have a president who is a current student member. A club will have one and only one president; a student may be a president of zero club or more than one club.Clubs hold events. Events have start date and time and end date and time. Events have name, description, and location (such as building and room number or the name and address of a venue).A club may hold as many events as it wishes or no event at all. Create an ERD for narrative using ERDPlus

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!