Question: Draw E-R (Entity-Relationship) diagrams only using EER notation, the Visio notation or the subtypes insides supertypes notation. - A nonprofit organization depends on a number
Draw E-R (Entity-Relationship) diagrams only using EER notation, the Visio notation or the subtypes insides supertypes notation.
- 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. Employees have only a Date Hired attribute, and volunteers have only a Skill attribute. Donors have only a relationship (named Donates) with an Item entity type. A donor must have donated one or more items, and an item may have no donors or one or more 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).
- In addition to the requirements specified in the problem, please add a subtype discriminator, called Person Type, to the E-R diagram.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
