solve

FIGURE P3.1 The Ch03_BeneCo Database Tables Database name: Ch03_BeneCo Table name: EMPLOYEE Table name: BENEFIT EMP_CODE EMP_LNAME JOB_CODE EMP CODE PLAN CODE 14 Rudell 2 15 NJ 15 McDade 15 10 Ruelardo 16 17 Smith 17 20 Smith 17 17 20 Table name: JOB Table name: PLAN JOB_CODE JOB DESCRIPTION PLAN_CODE | PLAN_DESCRIPTION 1 Clerical 1 Term life 2 Technical 2 Stock purchase 3 Managerial 3 Long-term disability 4 Dental Problem 1: For each table in the database above, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided. Use the following format to show your answers