Applying your knowledge in Enhanced Entity Relationship modeling, 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 6 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.
Applying your knowledge in Enhanced Entity Relationship modeling,
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 6
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
