Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

normalize this table to 1nf 2 nf 3 nf ( begin{array}{llllll}text { employee_id } & text { name } & text { job_code } &

normalize this table to 1nf 2 nf 3 nf
image text in transcribed
\( \begin{array}{llllll}\text { employee_id } & \text { name } & \text { job_code } & \text { job } & \text { state_code } & \text { home_state } \\ \text { E001 } & \text { Alice } & \text { J01 } & \text { Chef } & 26 & \text { Michigan } \\ \text { E001 } & \text { Alice } & \text { J02 } & \text { Waiter } & 26 & \text { Michigan } \\ \text { E002 } & \text { Bob } & \text { J02 } & \text { Waiter } & 56 & \text { Wyoming } \\ \text { E002 } & \text { Bob } & \text { J03 } & \text { Bartender } & 56 & \text { Wyoming } \\ \text { E003 } & \text { Alice } & \text { J01 } & \text { Chef } & 56 & \text { Wyoming }\end{array} \)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Oracle APEX 5 Application Development

Authors: Edward Sciore

2nd Edition

1484209893, 9781484209899