Draw.io ERD based on this database Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB_CODE 14 Rudell 15 McDade 16

Draw.io ERD based on this database

Transcribed Image Text:

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