Use the database shown in Figure P3.10 to work Chapter 3 Problems 10-16 on page 107. 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 MN relationship has been broken down into two 1M relationships for which the BENEFIT table serves as the composite or bridge entity FIGURE P3.10 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 15 McDade 16 Ruellardo 17 Smith 20 Smithh 17 20 Table name: JOB Table name: PLAN JOB_CODE JOB_DESCRIPTION PLAN CODE PLAN_DESCRIPTION Clericeal 2 Technical 3 Managerial 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental 10. 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. 11. Create the ERD to show the relationship between EMPLOYEE and JOB. 12. Create the relational diagram to show the relationship between EMPLOYEE and JOB. 13. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. 14. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. 15. Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. 16. Create the relational diagram to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN