Question: Design a relational database schema for the class diagram given below involving a database for charity. Primary keys and foreign keys should be specified to
Design a relational database schema for the class diagram given below involving a database for charity. Primary keys and foreign keys should be specified to the best of your ability. Wrote down any assumptions that are necessary to design the schema.

A Database for a Charity Organization Stopsat 1. * DonorAddress Address -City -Slate ZIP Code Donor Donor FirstName -LastName EmailAddress Phone Number Sets Enters 0. Donor Foodltem Description -Expiration Date 1. Route Route Date -Route Start Routo Finish 0.. ISA Has Found 1 Has Match Item Match Available Start 1. Available End 1.. Fooditem Fooditemid llom Name ISA Size 1 Has Charityltem Charity Food tam Amount Makes 1.. 1 1 Requests 0.. Charity CharityID Name Email Address Phone Number 1 HasCharity 1.. Charity Address Address City Stale ZIRCode
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
