Figure this out for class activity.

 

Use the database shown below. Note that the database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEES. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEES. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity. Table name: EMPLOYEE EMP CODE EMP_LNAME JOB_CODE 14 Rudell Database name: Ch03_BeneCo Table name: BENEFIT EMP_CODE PLAN_CODE 2 15 2 15 McDade 1 15 3 16 Ruellardo 1 16 1 17 Smith 3 17 1 20 Smith 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 For each table in the database, 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. TABLE PRIMARY KEY FOREIGN KEY(S) EMPLOYEE BENEFIT JOB PLAN