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. 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. Create the ERD to show the relationship between EMPLOYEE and JOB

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

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. 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. Create the ERD to show the relationship between EMPLOYEE and JOB

FIGURE P3.10 THE CH03_BENECO DATABASE TABLES
Database name: Ch03_BeneCo
Table name: EMPLOYEE
Table name: BENEFIT
EMP CODE PLAN_CODE
EMP CODE EMP_LNAME JOB_CODE
14 Rudell
15 McDade
16 Ruellardo
17 Smith
20 Smith
2
15
2
15
3
1
16
17
17
17
4
20
3
Table name: JOB
Table name: PLAN
JOB_CODE JOB_DESCRIPTION
1 Clerical
2 Technical
3 Managerial
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
ΕMPLOYΕE .
• 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.
10. 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.
11. Create the ERD to show the relationship between EMPLOYEE and JOB.
12. Create the relational diagram to show the relationship between EMPLOYEE and
JOB.
13. Do the tables exhibit entity integrity? Answer yes or no, and then explain your
answer.
14. 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.
15. Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and
PLAN.
16. Create the relational diagram to show the relationships among EMPLOYEE,
BENEFIT, JOB, and PLAN.
Transcribed Image Text:FIGURE P3.10 THE CH03_BENECO DATABASE TABLES Database name: Ch03_BeneCo Table name: EMPLOYEE Table name: BENEFIT EMP CODE PLAN_CODE EMP CODE EMP_LNAME JOB_CODE 14 Rudell 15 McDade 16 Ruellardo 17 Smith 20 Smith 2 15 2 15 3 1 16 17 17 17 4 20 3 Table name: JOB Table name: PLAN JOB_CODE JOB_DESCRIPTION 1 Clerical 2 Technical 3 Managerial 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 ΕMPLOYΕE . • 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. 10. 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. 11. Create the ERD to show the relationship between EMPLOYEE and JOB. 12. Create the relational diagram to show the relationship between EMPLOYEE and JOB. 13. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 14. 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. 15. Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. 16. Create the relational diagram to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY