Database:

a Relationships E EMPLOYEE EMP_COC - EMP_LNAM, JOB_COI, Click to Add + 14 Rudell 2 15 McDade 1 16 Ruellardo 1 17 Smith 3 20 Smith 2 PLAN BENEFIT Oo 1 PEF H PLAN_CODE PLAN_DESCRIPTION 1 EMP-CODE 1 PLAN_CODE EMPLOYEE BENEFIT EMP_COC, PLAN_COI , Click to Add , 15 2 15 3 16 1 17 1 1 47 17 3 17 17 20 3 0 0 0 1 EMP_CODE EMP_LNAME JOB_CODE oo 1 JOB JOB CODE JOB DESCRIPTION PLAN X + + PLAN_COC, PLAN_DESCRIPTION - Click to Add 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental 0 0 + ** 1. Identify the primary and foreign keys for each of the tables in the Cho3_Beneco database. Answer "none" if a table has no foreign keys. Type your answers in the empty cells of the following table. (40 points) EMPLOYEE EMP_CODE JOB JOB_CODE PLAN PLAN_CODE Primary key (PK) BENEFIT (EMP_CODE & PLAN CODE) (EMP_CODE & PLAN_CODE) Foreign Key (FK) JOB_CODE none none 2. What is the role of the BENEFIT table? What kind of relationship, 1:N, 1:M, or M:N, would have existed between the EMPLOYEE and PLAN tables without the BENEFIT table? (15 points) YOUR ANSWER: 3. Can the EMP_CODE attribute (column) in the BENEFIT table be a superkey? Explain your answer. (15 points) YOUR ANSWER: 4. What are the data types of the EMP_CODE and EMP_LNAME columns (fields) in the EMPLOYEE table? Because different DBMS use different names for similar data types, you must give a specific name of the data type in Access, such as Long Text. (15 points) YOUR ANSWER: 5. Switch to the Database Tools tab in Access and then click on the Relationships icon. Click on the relationship line connecting the EMPLOYEE and JOB tables to open the Edit Relationships window. Which check box in the Edit Relationships window is checked? What is the advantage of having it checked? (15 points) YOUR