Question: For part one, students are provided sample database tables. Students should determine if the sample tables provided are in 1 NF , 2 NF ,
For part one, students are provided sample database tables. Students should determine if the
sample tables provided are in NFNF or NF Provide a brief explanation why the table
design might be bad, if not in NF If the table is in NF no explanation is necessary.
EmployeeID Employee Name JobCode Job StateCode StateName
E John Jones J Chef Michigan
E Jack Anderson J Waiter Michigan
E Jean Kelly J Bartender Washingto
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
