2.1 Given Table Employee below change it to 2NF employee_id name job_code job state_code home_state Alice J01 Chef Michigan Alice J02 Waiter Michigan Bob J02 Waiter Bob J03 Alice J01 E001 E001 E002 E002 E003 26 26 56 Bartender 56 Chef 56 2.2 Given Table Employee below change it to 3NF employee_id name job_code Alice J01 Alice J02 Bob J02 Bob J03 Alice J01 E001 E001 E002 E002 E003 Wyoming Wyoming Wyoming job state_code home_state Chef Michigan Waiter Michigan Waiter Wyoming Wyoming Wyoming 26 26 56 Bartender 56 Chef 56

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
QUESTION 2
2.1 Given Table Employee below change it to 2NF
employee_id name job_code job state_code home_state
E001-
Alice J01
Chef
Michigan
E001
Alice J02
Waiter
26
Michigan
E002
Bob J02
Waiter 56
Wyoming
E002
Bob J03
Bartender 56
Wyoming
E003
Alice J01
Chef
56
Wyoming
2.2 Given Table Employee below change it to 3NF
employee_id name job_code
Alice J01
Alice J02
Bob
J02
Bob J03
Alice J01
E001
E001
E002
E002
E003
26
2
Cob
job state_code home_state
Chef
26
Michigan
Waiter
26
Michigan
Waiter 56
Wyoming
Bartender 56
Wyoming
Chef
56
Wyoming
(20)
[25
(1
Transcribed Image Text:QUESTION 2 2.1 Given Table Employee below change it to 2NF employee_id name job_code job state_code home_state E001- Alice J01 Chef Michigan E001 Alice J02 Waiter 26 Michigan E002 Bob J02 Waiter 56 Wyoming E002 Bob J03 Bartender 56 Wyoming E003 Alice J01 Chef 56 Wyoming 2.2 Given Table Employee below change it to 3NF employee_id name job_code Alice J01 Alice J02 Bob J02 Bob J03 Alice J01 E001 E001 E002 E002 E003 26 2 Cob job state_code home_state Chef 26 Michigan Waiter 26 Michigan Waiter 56 Wyoming Bartender 56 Wyoming Chef 56 Wyoming (20) [25 (1
Expert Solution
steps

Step by step

Solved in 3 steps

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