Answer to Question #220407 in Databases | SQL | Oracle | MS Access for Mingle

Question

Develop an EER model for the following situation:

A person may be employed by one or more organizations and each

organization may be the employer of one or more persons. An

organization can be internal organizational unit or an external

organization. For persons and organizations, we want to know their

ID, name, address and phone number. For persons we want to

know their birthdate, and for organizations, we want to know their

budget number. For each employment, we want to know the

employment date, termination date and bonus.

Employment of a person by an organization may result in the

person holding many positions over time. For each position, we

know its title, and each time someone holds that position, we need

to know the start date and termination date and salary. An

organization is responsible for each position. It is possible for a

person to be employed by one organization and hold a position for

which another organization is responsible.

Answer 1

The answer to your question is provided in the image: