Question: 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
normalize this table to 1nf 2 nf 3 nf \( \begin{array}{llllll}\text {

\( \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

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!