Question: Build a Logical ERD using the below business description. DonorZone is a nonprofit organization that helps wealthy donors donate funds to a wide variety of

Build a Logical ERD using the below business description. 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. Therefore, there is a M:N relationship between donors and causes. People are considered donors when the make their first donation. Causes can be listed in the database without having any donations. For donors, DonorZone wants to capture the Donorld, Name (FirstName, LastName), Address (StreetAddress, City, State, Zip), Phone Number(s) and Email Address(es). Each donor must provide at least 1 email & phone number. 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. For causes, DonorZone needs to track the CauselD, Name, and a Description of the cause. For donations, DonorZone needs to track which donor donated to which cause, amount donated, and the date of the donation. Assume each donor can donate to each cause no more than once per day
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
