Question: We are designing a database for a nonprofit organization. The organization depends on a number of different types of persons for its successful operation. The

We are designing a database for a nonprofit organization. The organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address(City/State/Zip), and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date_ Hired attribute, and volunteers have only a Skill attribute, and some volunteers may have more than one skills. Donor have a Donation_Type attribute. There are persons other than employees, volunteers, and donors who are of interest to the organization so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to two or more of these groups (e.g., employee and donor). Donors have only a relationship with an Item entity. Item entity has the following attributes: item ID, item Description. A donor can donated many items, and need to donate at least one item. An item may be donated by many donors, some item may have no donors.
We are designing a database for a nonprofit

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 Programming Questions!