Question: Use the figure below showing the tables in a database to answer the questions below Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB CODE Table name: BENEFIT


Use the figure below showing the tables in a database to answer the questions below Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB CODE Table name: BENEFIT EMP CODE PLAN CODE 14 Rucdell 15 McDade 16 Ruellardo 17 Smith 20 Smith 17 17 17 20 Table name: JOB Table name: PLAN JOB CODE JOB DESCRIPTION PLAN.CODE PLAN. DESCRIPTION 1Clerical 2 Technical 3 Managerial 1 Term life 2 Stock purchase 3 Long-term disabilit 4 Dental 3. 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. TABLE EMPLOYEE REFERENTIAL INTEGRITY EXPLANATION BENEFIT JOB PLAN 4. Create a basic Crow's Foot ERD to show the relationships among the EMPLOYEE, BENEFIT, JOB and PLAN tables. 5. What is a secondary key? List some examples of secondary keys 6. What is a composite key? Give an example of a composite key. Note: Try and give your answers for questions 5&6 based on the tables in the figure
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
