CS 105 Lecture 36 Relations

Employee Relation, version 1 [Figure 9.3]

Empl Id Name Address SSN
25X15 Joe E. Baker 33 Nowhere St. 111223333
34Y70 Cheryl H. Clark 563 Downtown Ave. 999009999
23Y34 G. Jerry Smith 155 Circle Dr. 111005555
: : : :

Employee Relation, version 2 [Figure 9.4]

Empl Id Name Address SSN Job Id Job Title Skill Code Dept Start Date Term Date
25X15 Joe E. Baker 33 Nowhere St. 111223333 F5 Floor manager FM3 Sales 9-1-2002 9-30-2003
25X15 Joe E. Baker 33 Nowhere St. 111223333 D7 Dept. head K2 Sales 10-1-2003 *
34Y70 Cheryl H. Clark 563 Downtown Ave. 999009999 F5 Floor manager FM3 Sales 10-1-2002 *
23Y34 G. Jerry Smith 155 Circle Dr. 111005555 S25X Secretary T5 Personnel 3-1-1999 4-30-2001
23Y34 G. Jerry Smith 155 Circle Dr. 111005555 S26Z Secretary T6 Accounting 5-1-2001 *
: : : : : : : : : :

Employee Relation, version 3 [Figure 9.5]

Empl Id Name Address SSN
25X15 Joe E. Baker 33 Nowhere St. 111223333
34Y70 Cheryl H. Clark 563 Downtown Ave. 999009999
23Y34 G. Jerry Smith 155 Circle Dr. 111005555
: : : :

Job Relation

Job Id Job Title Skill Code Dept
S25X Secretary T5 Personnel
S26Z Secretary T6 Accounting
F5 Floor manager FM3 Sales
: : : :

Assignment Relation

Empl Id Job Id Start Date Term Date
23Y34 S25X 3-1-1999 4-30-2001
34Y70 F5 10-1-2002 *
23Y34 S26Z 5-1-2001 *
: : : :
Last modified April 15, 2007