EMP CODE Table name: EMPLOYEE EMP_LNAME JOB_CODE Table name: BENEFIT EMP CODE PLAN_CODE 14 Rudell 2 15 2 15 McDade 1 15 3 16 Ruellardo 1 16 1 17 Smith 3 17 1 20 Smith 2 17 3 17 4 20 3 Database name: Ch03_BeneCo 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

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
icon
Related questions
Question
  • 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.

Question: For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None.

EMP CODE
Table name: EMPLOYEE
EMP_LNAME JOB_CODE
Table name: BENEFIT
EMP CODE
PLAN_CODE
14 Rudell
2
15
2
15 McDade
1
15
3
16 Ruellardo
1
16
1
17 Smith
3
17
1
20 Smith
2
17
3
17
4
20
3
Database name: Ch03_BeneCo
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
Transcribed Image Text:EMP CODE Table name: EMPLOYEE EMP_LNAME JOB_CODE Table name: BENEFIT EMP CODE PLAN_CODE 14 Rudell 2 15 2 15 McDade 1 15 3 16 Ruellardo 1 16 1 17 Smith 3 17 1 20 Smith 2 17 3 17 4 20 3 Database name: Ch03_BeneCo 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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning