Use the database shown in Figure P3.10 to work Problems 10-15. 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. FIGURE P3.10 The Ch03 BeneCo Database Tables Table name: EMPLOYEE EMP CODE EMP LNAME JOB CODE 14 Rudel 15 McDade 16 Ruelardo 17 Smith 20 Smith Database name: Ch03_BeneCo Table name: BENEFIT EMP CODE PLAN CODE 15 15 16 1 17 1 17 3 17 20 Table name: JOB JOB CODE JOB DESCRIPTION 1 Clerical Technical 3 Managerial Table name: PLAN PLAN CODE PLAN DESCRIPTION 1 Termite 2 Stock purchase 3 Long-term disability 4 Dental Page 1 hapter 3 Problems 14. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write N4 (Not Applicable) if the table does not have a foreign key. TABLE EMPLOYEE BENEFIT JOB PLAN REFERENTIAL INTEGRITY EXPLANATION S 15. Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB. and PLAN PhotoGrid