Answered step by step
Verified Expert Solution
Link Copied!

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.

  1. A student organization has a name, a brief description, a category (professional, academic, athletic, etc.), and a general target audience (undergraduates, graduates).
  2. 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).
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions

Question

What does Processing of an OLAP Cube accomplish?

Answered: 1 week ago