Question: FIGURE P 3 . 1 0 THE CHO 3 _ BENECO DATABASE TABLES Table name: EMPLOYEE EMP _ CODE EMP _ LNAME JOB _ CODE
FIGURE P THE CHOBENECO DATABASE TABLES Table name: EMPLOYEE EMPCODE EMPLNAME JOBCODE Rudell McDade Ruellardo Smith Smith Database name: ChBeneCo Table name: BENEFIT EMPCODE PLANCODE Table name: JOB JOBCODE JOBDESCRIPTION Clerical Technical Managerial Table name: PLAN PLANCODE PLANDESCRIPTION Term life Stock purchase Longterm disability Dental Use the database shown in Figure P to work Problems Note that the database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOBCODE, but a JOBCODE can be held by many EMPLOYEES. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEES. Note also that the M:N relationship has been broken down into two :M relationships for which the BENEFIT table serves as the composite or bridge entity. OCreate the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
