Sooner Cares Food Bank holds a series of charitable events every year to raise money for their
Question:
Sooner Cares Food Bank holds a series of charitable events every year to raise money for their organization. The organization would like you to draw an ERD diagram that depicts the database they would like to build to track pertinent information regarding their charitable events.
The organization holds multiple events a year. They would like you to track the name of the event, the purpose of the event (e.g., raise funds, obtain food donations, support people with food insecurity, organizational operational support), and the date of the event (day, month, year). The organization would like to track data concerning the venue in which they hold each event. This information includes the venue name, the venue contact (title, first name, last name), the venue address (street, city, state, zip), the venue phone numbers, and the venue email addresses. The organization may choose to hold multiple events at various venues. The organization sends its valued patrons invitations to all events. The organization would like to track the following patron data: patron first name, patron last name, patron address (street, city, state, zip), patron phone number, patron email address, date (day, month, year) the patron became support of the organization, and the number of years the patron has been a supporter of the organization. Patrons are invited and encouraged to attend as many events as possible at a given event venue. If a patron attends an event at a venue - the organization would like to track their attendance at the event and how much the patron donated to the organization during the event.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi