Design a relational database schema for the class diagram given below. Primary keys and foreign keys should be specified too.

After you've made your relational database write down any other assumptions.

Donor - DonorID -FirstName -LastName -EmailAddress -PhoneNumber

DonorAddress -Address -City -State -ZipCode

DonorFoodItem -Description - Expiration Date

Route -RouteID -Date -RouteStart -RouteFinish

ItemMatch -AvailableStart -AvailableEnd

CharityFoodItem -Amount

Food item -FoodItem -FoodName -Size

Charity -CharityID -Name -EmailAddress -PhoneNumber

CharityAddress -Address -City -State -Zip Code

A Database for a Charity Organization Siopsi DoworAddre 1. Addo HCILY SA 421 POnde Donor Donor FirstName LastNam Email Address PhoneNumber Sets 1 En ON DonorFooditem Description Expeation Date 1. Route ROULD Dete Route Start -RoutFinish ISA Has Found 1 Has Match ItemMatch LAvailables are 1. Available Feest Fooditem SonName D Has Charityitem 1 Charity Fooditem Amount lakes 1 1 Reques OM Charity -Charity Name Email Address PhoneNumber 1 HasCharity 1 Charity Address Address CY Stale L2RCON