Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You will be graded on appropriate naming conventions for entities, attributes, and relationships and an appropriate representation of the business rules. State any assumptions you
You will be graded on appropriate naming conventions for entities, attributes, and relationships and an appropriate representation of the business rules. State any assumptions you have made.
Create a complete Crows Foot ERD with the following business rules:
The University would like to track information about Student Organizations. Specifically, they would like to track students in each student organization, the student leaders, and the different events that are hosted throughout the year.
- A student organization has a name, a brief description, a category (professional, academic, athletic, etc.), and a general target audience (undergraduates, graduates).
- Each student organization has at least 5 or more student members. A student can be a member of zero or more organizations. At a minimum, the system needs to report on student name, email, phone, major, and classification (undergraduate or graduate).
- Each student organization has at least one or more student leaders. Leadership position titles and the number of leaders are specific to each student organization.
- A student can be a leader in 0 or more student organizations. For each student organization, the university needs to know the student first name, last name, email, and the position they hold.
- A student organization hosts various events throughout the year. The university would like to know about these events. They would like to know the date, time, location, semester, and event type. A student organization can host zero or more events throughout the year. Each event is hosted by 1 and only 1 student organization.
- Students attend these events. The university would like to know how many students are attending the events. A student can attend zero or more events and an event can be attended by zero or more students. Students do not have to be a member of the student organization to attend an event.
- Finally, sometimes the student organizations have special guests at their events. The university would like to track information about these guests such as the guest name, email, company, and if they are an alumni. An event can have zero or more special guests and a guest may attend a single event at a time. They would also like to know the reason for attending an event (Note, this will vary by event by guest).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started