Scenario:

You have been asked to design a database system for DonationDollars, a company that wants to facilitate donations to non-profit organizations via an online service. To do this, Donation Dollars presents an online profile for each company on a website. Here, other people can make donations to the cause. The website shows the number of dollars gathered in a given time, the people who donated (can be by name or anonymous) and the amount of money donated.

In addition to facilitating this exchange online, Donation Dollars needs to transfer all money to the correct organization, send a thank-you letter to the person who is donating the money (for tax deduction purposes) and keep track of the total amounts of dollars donated to all different companies.

For example, one organization that uses DonationDollars could be the Pet Orphanage, a shelter for animals. As an individual, you can donate money online to the Pet Orphanage using the website put up by Donation Dollars.

Question:

Create the entity relationship diagram (ERD) for an appropriate data model. Be sure to indicate the identifier for each entity and the relationships including cardinalities and any cardinality constraints between entities. There should be a minimum of 4 entities.

Scenario: You have been asked to design a database system for DonationDollars, a company that wants to facilitate donations to non-profit organizations via an online service. To do this, DonationDollars presents an online profile for each company on a website. Here, other people can make donations to the cause. The website shows the number of dollars gathered in a given time, the people who donated (can be by name or anonymous) and the amount of money donated. In addition to facilitating this exchange online, DonationDollars needs to transfer all money to the correct organization, send a thank-you letter to the person who is donating the money (for tax deduction purposes) and keep track of the total amounts of dollars donated to all different companies. For example, one organization that uses DonationDollars could be the Pet Orphanage, a shelter for animals. As an individual, you can donate money online to the Pet Orphanage using the website put up by DonationDollars. Question: Create the entity relationship diagram (ERD) for an appropriate data model. Be sure to indicate the identifier for each entity and the relationships including cardinalities and any cardinality constraints between entities. There should be a minimum of 4 entities