Create the entity relationship diagram (ERD) using Microsoft visio 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.

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) using Microsoft visio 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.

You must use MS Visio to create the ERD. You must use MS Visio notation as discussed in class.

The file upload must be a pdf or jpg or png.

Requirements: 4 Entities