Answered step by step
Verified Expert Solution
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, CityStateZip 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 eg 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:
Identify the Entities
Get the relationships
Supertype or subtypes
Ge the attributes, PK FK
Determine the cardinalities.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started