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 1NF,2NF, or 3NF. Provide a brief explanation why the table
design might be bad, if not in 3NF. If the table is in 3NF, no explanation is necessary.
1.)
Employee_ID Employee Name Job_Code Job State_Code State_Name
E001 John Jones J01 Chef 26 Michigan
E002 Jack Anderson J02 Waiter 26 Michigan
E003 Jean Kelly J03 Bartender 1 Washingto

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!