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
Get step-by-step solutions from verified subject matter experts
