Question: FIGURE P 3 . 1 0 THE CHO 3 _ BENECO DATABASE TABLES Table name: EMPLOYEE EMP _ CODE EMP _ LNAME JOB _ CODE

FIGURE P3.10 THE CHO3_BENECO DATABASE TABLES Table name: EMPLOYEE EMP_CODE EMP_LNAME JOB_CODE 14 Rudell 215 McDade 116 Ruellardo 117 Smith 320 Smith 2 Database name: Ch03_BeneCo Table name: BENEFIT EMP_CODE PLAN_CODE 152153161171173174203 Table name: JOB JOB_CODE JOB_DESCRIPTION 1 Clerical 2 Technical 3 Managerial Table name: PLAN PLAN_CODE PLAN_DESCRIPTION 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental Use the database shown in Figure P3.10 to work Problems 10-16. Note that the database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOB_CODE, but a JOB_CODE 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 1: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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!