Build a Logical ERD using the below business description. wwwmmmmmmmmm DonorZone is a nonprofit organization that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Build a Logical ERD using the below business description. wwwmmmmmmmmm 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 DonorID, 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 CauseID, Name, and a Description of the cause. wwwwwwwwwwww 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. Build a Logical ERD using the below business description. wwwmmmmmmmmm 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 DonorID, 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 CauseID, Name, and a Description of the cause. wwwwwwwwwwww 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.
Expert Answer:
Related Book For
Business Statistics
ISBN: 9780321925831
3rd Edition
Authors: Norean Sharpe, Richard Veaux, Paul Velleman
Posted Date:
Students also viewed these databases questions
-
In your opinion, Is the custodial model most appropriate for organizing prisons that operate at different security levels? What model should be used to organize a minimum-security facility?
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Create an ERD diagram that supports the business operations. Please make sure that the primary keys underlined and please make sure that all the relationships are connected to the right entries. Also...
-
A 10.231-g sample of window cleaner containing ammonia was diluted with 39.466 g of water. Then 4.373 g of solution were titrated with 14.22 mL of 0.1063 M HCl to reach a bromocresol green end point....
-
Consider the current transformer of Problem 2.32. a. Use MATLAB to plot the percentage error in current magnitude as a function of the magnitude of the burden impedance (i) for a resistive burden of...
-
The board of directors of Gemstar Instruments is having its quarterly meeting. Accounting policies are on the agenda, and depreciation is being discussed. A new board member has some strong opinions....
-
Research and prepare a report on the different approaches for accounting for carbon emissions under the EU ETS.
-
Marathon Running Shop has two service departments (advertising and administration) and two operating departments (shoes and clothing). During 2013, the departments had the following direct expenses...
-
18.A sine wave is travelling in a medium. The minimum distance between the two particles, always having same speed, is (1) (2)
-
George Pharmacy is a pharmaceutical salesman who has been very successful at his job in the last few years. Unfortunately, his family life has not been very happy. Three years ago, his only child,...
-
Paula Beane owns a restaurant franchise that is part of a chain of southern homestyle restaurants. One of the chains popular breakfast items is biscuits and gravy. Central Warehouse makes and freezes...
-
In using marginal analysis with the normal distribution, if marginal profit is less than marginal loss, we expect the optimal stocking quantity to be a. greater than the standard deviation. b. less...
-
Why is the annual purchase (material) cost not considered to be a relevant inventory cost if the EOQ assumptions are met? a. This cost will be zero. b. This cost is constant and not affected by the...
-
LP sometimes uses case studies, examples, or tools in specific disciplines. For example, the blending problem is: a. including the diet problem. b. used when mixing resources to produce one or more...
-
In a standard normal distribution, the mean is equal to a. 1. b. 0. c. the variance. d. the standard deviation.
-
What is inflation? How have courts determined the appropriate measure of inflation for judicial decisions? Should awards be adjusted for inflation? Why?
-
Question 16 10 points As shown in the figure below, assume that 0=1150 and the jet has a velocity of 25 m/s and a diameter of 40 mm. What is the component of the force acting on the blade in the x-...
-
Represent each of the following combination of units in the correct SI form using an appropriate prefix: (a) m/ms, (b) k m, (c) k s /mg, and (d) k m N.
-
An industrial machine requires an emergency shutoff switch that must be designed so that it can be easily operated with either hand. Design an experiment to find out whether workers will be able to...
-
Its common folk wisdom that cranberries can help prevent urinary tract infections in women. A leading producer of cranberry juice would like to use this information in their next ad campaign, so they...
-
A soap manufacturer tested a standard bar of soap to see how long it would last. A test subject showered with the soap each day for 15 days and recorded the Weight (in grams) of the soap after the...
-
Bright Horizons Skilled Nursing Facility, an investor-owned company, constructed a new building to replace its outdated facility. The new building was completed on January 1, 2015, and Bright...
-
Brandywine Homecare, a not-for-profit business, had revenues of \($12\) million in 2015. Expenses other than depreciation totaled 75 percent of revenues, and depreciation expense was \($1.5\)...
-
What is the relationship between the retained earnings account on the balance sheet and earnings (net income) reported on the income statement?
Study smarter with the SolutionInn App