On the topic of Software Engineering

Design a relational database schema by hand or online for the class diagram given below. Primary keys and Foreign keys should be specified too. Wrote down any assumptions that are necessary to design the schema

A Database for a Charity Organization StopsAt Donor Donor D FirstName LastName EmailAddress Phone Number DonorAddrose Address City State ZIP Code Sets 1.1 1 Enters 0. Donor Foodltem Description -Expiration Dale Route Route Date Route Start Route finish Has Found 1 Has_Match ItemMatch AvailableStart 1... Available End Fooditem Fosdilemia dem Name ISA Size Has Charityltem 1 Charity Fooditem Amount Makes 1.. Requests Charity Charity Name Email Address Phone Number HasCharity Charity Address Address City State ZIP Code