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.

Design a relational database schema for the class diagram given below involving

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!