DATABASE SYSTEMS Database Systems Test #1 Use the database diagrammed below to show to complete the following section. Note that the database is composed of four tables and reflects these relationships. H. * An EMPLOYEE has only one JOB CODE, but a JOB CODE can be held by many EMPLOYEEs An EMPLOYEE can have many BENEFITs, and any BENEFIT can be assigned to many EMPLOYEEs Note that the M:N relationship has been decomposed into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity Database name: Corporate Table name: EMPLOYEE Table name: BENEFIT EMP EMPL 15 McDade Table name: JOB Table name: PLAN J08 2Technica 3 Managerial 2 Stock purchase 3 Long-erm 4 Derea I. 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. (4 points) Table Primary key Foreign Key(s) EMPLOYEE BENEFIT JOB PLAN 2. Do the tables exhibit entity integrity? Answer Yes or No, then explain your answer. (4 points) Entity Integrity? Explanation able MPLOYEE ENEFIT AN