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?