On the Subject of Software Engineering 2

How would one design a relational database schema for the class diagram given below, Primary keys and foreign keys should be specified too. write down any assumptions that are necessary to design the schema

A Database for a Charity Organization Stopsat 1.. DonorAddross Address City State -ZIPCode Donor Donor FirstName -LastName Email Address Phone Number Sets 1.." Enters 0.. DonorFooditem Description -Expiration Dale 1. Route -Routes Date -Route Start -RouleFinish ISA Has Found Has_Match Item Match -Available Start 1.. Available End 1..* Fcoditem Food items -itemName Size 0.." ISA Has Charityltem Charity Fooditem -Amount Makes 1 1 Requests 0.. Charity CharityID -Name -Email Address PhoneNumber HasCharity 1.. Charity Address Address -City Stale -ZIP Code A Database for a Charity Organization Slopsat DonorAddress Donor Donor FirstNamo LastNamo EmailAdd oss Phone Number Addross City State ZIP Code 1 Sets 1. Entors 0.- Donor Foodilem Description ExpirationDalo 1 1.- Routo ROULD Dato Routostart RoutoFlush 0 0.. 15. Has found 1 her Match Has Match Availables 1. AwallabloEnd 2920 1. 00 + Fooditems FooditemID AllemNomo Size ISA Makes Has Charityltem 1 CharltyFooditem Amount 1.. 1 1 Requests 0... Charity Charity Namo Emo Address Phone Number 1 HasCharity Charity Address Address City Stale ZIP Codo