You are provided below a design of a relational database for a non$-$profit organization that is

concerned with the welfare of poor people in your community. It accepts donations from people.

Donations could be either money or products. It processes the items and sells them to the local

people who are interested in them. Part of the donations are used to cover the expenses to run the

organization and the rest is used to help poor people in the community. The database contains

information about Donors, Donations, Products, Sales and SalesItems.

Donors is the relation that holds information about the people who donate to the organization.

Every donor has an ID$,$first$-$name, last$-$name, middle$-$initial, date$-$of$-$birth, address, gender, phone$-$

number, email$-$address, and social security number.

Donations is the relation that holds information about each donation. Every donation has an ID$,$

the donor ID$,$date of the donation, type of donation, and amount of donation.

Products is the relation that holds information about every item donated. Every product has an ID$,$

the description of the product, the donation date of the product, the selling price of the product, the

weight $($in Kilogram$)$of the product, a flag indicating whether the product is in stock or has been

sold, the location of the product is a string that contains where the product is stored, and the color

that could be either unknown or any other know color.

Sales is the relation that holds the information about the items sold. Every sale has an ID$,$date of

the sale, amount of the sale, total weight $($in kilogram$)$of the sale, and the delivery fee if the sale

is to be delivered