Microsoft Office Tutorials and References
In Depth Information
Figure A-20
Using surrogate keys
foreign key
Employee
surrogate key
EmployeeSK
EmployeeNum
FirstName
LastName
HealthSK
1
2173
Barbara
Hennessey
2
2
4519
Lee
Noordsy
1
3
8005
Pat
Amidon
3
4
8112
Chris
Wandzell
1
HealthBenefits
surrogate key
HealthSK
HealthPlan
PlanDesc
1
A
Managed PPO
2
B
Managed HMO
3
C
Health Savings
Position
artificial key
PositionID
PositionDesc
PayGrade
1
Director
45
2
Manager
40
3
Analyst
30
4
Clerk
20
foreign key
Employment
surrogate key
EmploymentSK
EmployeeSK
PositionID
StartDate
1
1
2
12/14/2008
1
2
1
04/23/2010
1
4
3
11/11/2004
2
2
3
06/05/2009
3
1
4
07/02/2007
3
2
1
12/15/2009
4
3
2
10/04/2008
 
Search JabSto ::




Custom Search