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