Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DRAW an EER diagram ( EERD ) that can be implemented for a nonprofit organization using the following business rules: A nonprofit organization depends on

DRAW an EER diagram (EERD) that can be implemented for a nonprofit organization using the following business rules:
A nonprofit 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. 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). If the donor wants to donate to a specific person, the specific person is stored. Employee have only a Date Hired attributes, and volunteers have only a Skill attribute. A donor must have donated one or more items, and an item may
have no donors, or one or more donors. Each item is recorded for its monetary value. Also, the organization records the date of donation. The organization only allows one person to donate once a day. Therefore, the person's data and the date of donation make it possible to uniquely identify the donation.
Clue:
1. Identify the Entities
2. Get the relationships
3. Supertype or subtypes
4. Ge the attributes, PK, FK.
5. Determine the cardinalities.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago