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

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 General Management Questions!