Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 2. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. TABLE EMPLOYEE ENTITY INTEGRITY EXPLANATION BENEFIT JOB PLAN 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started