A non-profit 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, date of birth and telephone number. The organization also needs to know the age of the person in any given time. Three types of persons of greatest interest to the organization are employees, volunteers and donors. For each employee, date of hiring is needed while for the volunteers, their skill is also gathered. Donors only have a relationship (named Donates) with an item entity type whose attributes include item_no and description. The date of donation of the item is also recorded. A donor must have donated one or more items, but an item may have one or more donors or no donor at all. There are persons other than employees, volunteers or donors who are of interest of the organization, so that the person need not belong to any of three groups. On the other hand, at a given time a person may belong to two or more of these groups (for example, employee and donor).
Draw an Enhance ER diagram for the given situation. (20 points)
A non-profit 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, date of birth and telephone number. The organization also needs to know the age of the person in any given time. Three types of persons of greatest interest to the organization are employees, volunteers and donors. For each employee, date of hiring is needed while for the volunteers, their skill is also gathered. Donors only have a relationship (named Donates) with an item entity type whose attributes include item_no and description. The date of donation of the item is also recorded. A donor must have donated one or more items, but an item may have one or more donors or no donor at all. There are persons other than employees, volunteers or donors who are of interest of the organization, so that the person need not belong to any of three groups. On the other hand, at a given time a person may belong to two or more of these groups (for example, employee and donor).
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
