Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create the ERD to show the relationship between EMPLOYEE and JOB. FIGURE P3.10 THE CH03 BENECO DATABASE TABLES Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB_CODE 14
Create the ERD to show the relationship between EMPLOYEE and JOB. FIGURE P3.10 THE CH03 BENECO DATABASE TABLES Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB_CODE 14 Rudell 15 McDade 16 Ruellardo 17 Smith 20 Smith Table name: JOB JOB_CODE JOB DESCRIPTION 1 Clerical 2 Technical 3 Managerial 2 1 1 3 2 Table name: BENEFIT EMP_CODE PLAN_CODE 15 15 16 17 17 20 2 3 1 Database name: Ch03_BeneCo 4 3 Table name: PLAN PLAN_CODE PLAN_DESCRIPTION 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental
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