Question: Design a database system for Donation Dollars, a company that wants to facilitate donations to non-profit organizations via an online service. To do this, Donation

Design a database system for Donation Dollars, 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, 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.

Design a database for this project.

Show the ER diagram for your database. There should be at least 4 entities with their relations. Clearly describe and explain all the symbols you use for your ER diagram.

Show the corresponding Relational Model

Explain the difference between an ER diagram and your Relational Model showing the tables.

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!

Which of the following positions would require a Master's degree? Multiple Choice information security analyst genetic counselor event planner market research analyst

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...

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...

Use DRAW.IO to create the ERD 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...

Directions You can use MS Visio,or Lucid Chart,or Draw.io or any other case tool to create the ERD.You must use the MS Visio notation for the ERD.You submission must be a pdf , or jpg , or png file...

In this milestone, you will submit a draft of Section I (introduction) and Section II (verification plan) to include all critical elements. The introduction provides an overview of the IT problem you...

MRKT 310 Principles of Marketing Strategic Marketing & Value for the Customer Please use the service offering below; Lyft PRODUCT CHOICE & CONTENT Your focus will be on the domestic, or U.S....

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

Discuss your system verification plan, feedback plan, feedback criteria, and test cases. How are you planning to demonstrate that your system meets the specified requirements? How are you going to...

Business and Society Stakehol... Chapter 18 The Community and the Corporation 395 396 Part Six Business and Its Stakeholders Salesforce.com, a cloud computing company based in San Francisco, develops...

2012 Annual Report Our \"bottom line\" ultimately depends on our ability to satisfy all of our stakeholders. Our goal is to balance the needs and desires of our customers, team members, shareholders,...

The following equilibrium constants were determined at 1123 K: Write the equilibrium constant expression KP, and calculate the equilibrium constant at 1123 K for C(s) + CO2(g)--2CO(g) CO(g) + Cl2(g)...

(a) List the four classifications of steels. (b) For each, briefly describe the properties and typical applications.

Money laundering depends on the existence of an underlying crime, while terrorist financing does not. Money laundering investigations are initiated to achieve prosecution and forfeiture. Terrorist...

i) Masse Corporation uses part G18 in one of its products. The company's Accounting Department reports the following costs of producing the 16,000 units of the part that are needed every year. An...

3. Can the employees demonstrate the correct knowledge or behavior? Perhaps employees were trained but they infrequently or never used the training content (knowledge, skills, etc.) on the job. (This...

6. Discuss the steps involved in conducting a task analysis.

8. Explain competency models and the process used to develop them.