Question: normalize this table to 1nf 2 nf 3 nf ( begin{array}{llllll}text { employee_id } & text { name } & text { job_code } &
\( \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
Get step-by-step solutions from verified subject matter experts
