For each table, identify the primary keys and the foreign 

key(s). If a table does not have a foreign key, write None in the space provided.

Employee Table:

-Primary key_____

-Foreign Key_____

Benefit:

-Primary key_____

-Foreign Key_____

Job:

-Primary key_____

-Foreign Key_____

Plan:

-Primary key_____

-Foreign Key_____

 

EMP_CODE Table name: EMPLOYEE EMP_LNAME JOB_CODE Table name: BENEFIT EMP_CODE PLAN_CODE 14 Rudell 2 15 2 15 McDade 1 15 3 16 Ruellardo 1 16 1 17 Smith 3 17 1 20 Smith 2 778 17 3 17 4 20 3 Table name: JOB JOB CODE JOB DESCRIPTION 1 Clerical 2 Technical 3 Managerial Table name: PLAN PLAN CODE PLAN_DESCRIPTION 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental