= PK JOB JOB_CODE JOB DESCRIPTION PK PLAN PLAN_CODE EMPLOYEE PK EMP_CODE EMP_LNAME PLAN DESCRIPTION FK JOB_CODE C -I BENEFIT FK EMP_CODE FK PLAN_CODE Table name: EMPLOYEE Database name: Ch03_BeneCo Table name: BENEFIT EMP_CODE PLAN_CODE EMP_CODE EMP_LNAME | JOB_CODE 14 Rudell 2 15 2 15 McDade 1 15 3 16 Ruellardo 17 Smith 20 Smith 1 16 1 3 17 1 2 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