Answered step by step
Verified Expert Solution
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 \( \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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started