Question: Build a Logical ERD using the below business description (Note: please write down any assumptions you make). DonorZone is a nonprofit organization that helps wealthy

Build a Logical ERD using the below business description (Note: please write down any assumptions you make).

DonorZone is a nonprofit organization that helps wealthy donors donate funds to a wide variety of causes for people in need.

When a donor donates money, they choose which cause they want to donate to. A donor can donate to 1 or many causes, and each cause can have 0 or many donors.

For donors, DonorZone wants to capture the DonorID, Name (FirstName, LastName), Address (StreetAddress, City, State, Zip), Phone Number(s) and Email Address(es). Each donor must provide at least 1 phone number and at least 1 email address. If a donor provides more than 1 phone number or email address, DonorZone wants to capture all of them. Therefore, phone number & email address are multivalued attributes of donors. Each phone number and email address stored in the database must belong to only 1 donor.

For causes, DonorZone needs to track the CauseID, Name, and a Description of the cause. For donations, DonorZone needs to track which donor donated to which cause, how much money they donated, and the date of the donation. A donor can donate money for the same cause at different dates.

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 Databases Questions!