The local Salvation Army wants to keep track of donors and donations. They have asked you to create a small database to do this for the organization. The receipt generated for each donation is provi
IT 378 Homework 1 Prepare an ER diagram for the application described below. Be sure to identify all required entities, attributes, and relationships (including cardinalities). State any assumptions you make, and indicate a primary key for each entity. Remember that hand-drawn diagrams will NOT be accepted. 1) The local Salvation Army wants to keep track of donors and donations. They have asked you to create a small database to do this for the organization. The receipt generated for each donation is provided below. The sample below has been filled out with data for your information. The items received are always a little different – there is no set group of items received by the organization, and no item numbers assigned to those items. Salvation Army 1742 W. Lindsey Norman, OK 73069 Donation Receipt Number: Date: 475972 03/15/21 Donor Information Name Katherine Jamison Address 123 Main Street City, State, Zip Norman, OK 73072 Telephone 405-325-3000 Pickup? Delivery? Item Information Description Estimated Age Estimated Initial Price Estimated Current Value Clothes 10 years 1,000 100 Books 5 years 200 15 Children’s videos 6 years 250 25 2) Modify the assumptions for question 1. Assume that there are set items that the Salvation Army accepts as donations. These items are categorized into groups such as “clothes,” “books,” “furniture,” “videos,” “appliances,” etc. The estimated age, price and current value are always different, however, depending on the actual item donated. The Salvation Army wants to keep track of which donors donate which items. How would your design change? 3) What are the strengths and weaknesses of the two alternative designs created for questions 1 and 2?