Add the following to Figure 3-16: An EMPLOYMENT party relationship is further explained by the positions and assignments to positions during the time a person is employed. A position is defined by an organization unit, and a unit may define many positions over time. Over time, positions are assigned to various employment relationships (i.e., somebody employed by some organization unit is assigned a particular position). For example, a position of Business Analyst is defined by the Systems Development organization unit. Carl Gerber, while employed by the Data Warehousing organization unit, is assigned the position of Systems Analyst. In the spirit of universal data modeling, enhance Figure 3-16 for the most general case consistent with this description.

Transcribed Image Text:

PARTY RELATIONSHIP From Date Thru Date ORG-TO-ORG PERSON-TO-ORG RELATIONSHIP RELATIONSHIP ORG CONTACT ORG CUSTOMER Indicates when a EMPLOYMENT PARTNERSHIP RELATIONSHIP or ROLE Is In effect To From Involves Involved In PARTY ROLE PERSON ROLE From Date EMPLOYEE CONTACT Thru Date Of ROLE TYPE Role Type ID Used ORGANIZATION CUSTOMER ORGANIZATION UNIT ROLE to Identify BILL TO CUSTOMER SUPPLIER DEPARTMENT Current Last Name For Acting As PARTY PERSON ORGANIZATION Party ID