The following table is un-normalized. I The original data set is in the Normalization Lab Data xls file in your lab folder. For each question that requires you to re-write tables, re write them in the Excel workbook and copy/paste your new table(s) in the appropriate sections below. Tables must include all data (not merely column headings). To make your results more readable, paste your tables as bitmaps or screenshots. To receive credit for these questions, your tables must be easily readable. You may refer to the Normalization Example.xls file as an example on how to approach this task. This file located in your lab folder Hest Last Office Project Emp Name Name office Address Supervben Prolet Manager Clent inte Acme CWO Peter Parker Acme, uc 1/15/2018 1/16/2013 14566 Central Road sameston Enterprises - WO Oliver Curen Lameston Enterprises 1/17/2018 253 Peter Parker Metropolis Metropolis. IL 23456 Bruce Wayne 1/1/18 Satele, Inc. - Ukense Bruce Wayne Gatele, Inc 1/15/2018 1/16/2018 1/17/2018 123 Oak Lane VW2018 987 Bruce Wayne Gotham Gotham, NY 45632 1/19/2018 Quartz United - Software Upgrade Gark Kent Quartt United 1/15/2018 1/16/2013 14506 Central Road mec - WOH2 Peter Parker Acme, LLC 1/17/2018 52 Gakken Metropol Metropolis, IL 23456 Bruce Wayne Lone & Jones WON Clark Kent Jones & Bones 1/16/2016 lones Lot - Maintenance Dark Kent Jones los 1/15/2018 Briarwoline TEM Skywalkerwood, in 1/10/2018 1/17/2018 123 akan Lghter, Leo & Skywalkerugiaber, 1/11/2016 333 Luke Skywalked clotham Over United Clark Kent buat United 1/1/2018 Gotham, NY 45832 1/15/2017 Hondon L-Cum Oliver Queen Houndson und Meston Enterprise WOW biver den meston tarpees16/2017 BrowoTEM LR Skywalker Briarwood 1/2017 1/11/2012 1458 Central Brod, in te 1/10/2017 Le Skywalkerwood 1/11/2017 536 Over Queen Me the big 3 2 6 4 : THE LEG | | Focu Question 1: In the space below, re-write the table above so that it is in first normal fo C G 1 Empid FirstName Last Name Office Office Address Supervisor Project Project manager Cilent Date Hours Worked 16566 Central Road 2 253 Peter Parker Metropolis Metropolis, 123456 Bruce Wayne Acme LLC-WOR Peter Parker Acme, 1/15/2018 14566 Central Road 3 253 Peter Parker Metropolis Metropolis, 112456 Bruce Wayne Acme c-WO Peter Parker Acme LC 1/1/2018 14566 Central Road 253 Peter Parker Metropolis Metropolis, 112156 Bruce Wayne Jameson Enterprises Wom Oliver Queen Jameston Enterprises 1/17/2018 14566 Central Road 5 253 Peter Metropolis Metropolis, 11256 Bruce Wayne ameston Enterprises-WO Obver Queen meston Enterprises 1/18/2018 123 Oak Lane Gotham 6 967 Bruce Wayne Gotham NY45632 Gatelle, Inc. License Gutelle, in Bruce Wayne 1/15/2010 123 Oak Lane Gotham 7 Gatele, Inc 987 Bruce 1/1/2018 Wayne NY 45632 Gateleine License Gotham fice Wayne 121 Oak Lane Gotham, 1/17/2018 Bruce Wayne Gatelle, in 987 Biru Gate, Inc Wayne Gotham NY 45612 123 O Lane Gotham uce Wayne 1/10/2011 Gatelle, 957 Bruce Wayne NY 45633 Outene License Gotham 123 Okane Gotham Arne Wahn 1/19/2018 Gatele. In Gatine 13 987 Bruce Wayne Gotham NY 45632 14506 Central Road Quan United Bruce Wayne Quarted software Upgrade Caront 1/1/2018 Minden 52 Clark Kent Metropolis Metropolis, 1123456 Editing Voice 12 52 Clark Kent Bruce Wayne Quarta United Software upgrade Clark Kent 13 52 Clark Quarta United Kent 1/1/2018 Bruce Wayne Acme c-WO 14 Peter Parker 52 Clark Acme. C Kent 1/17/2018 Bruce Wayne Jones & Jones - WOW Clark Kent Jones & Jones 15 333 Luke /1/2018 Skywalker Oliver Queen Jones & Maintenance Clark Kent ones Jones 1/1/20 16 333 Luke Skywalker 14546 Central Road Metropolis Metropolis, 1123456 11566 Central Road Metropolis Metropolis, 1123436 14566 Central Road Metropolis Metropolis, 1123456 123Oak Lane Gotham Gotham NY 45612 123 Oak Lane Gotham Gotham NY 45612 123 Oak Lane Gotham Gotham NY 45632 123 Okane Gotham Gotham NY 45632 121 Oak Lane Gotham Gotham NY 45612 14566 Central Road Metropolis Metropolis, 123456 1456 Central Road Metropolis Metropolis, 11256 Oliver Queen Bierwood, inc-TEM wake Sywalker Brierwood, Inc 1/18/2018 Skywalker Oliver Queen Berwood, In TEM Luke Skywalker Drienwood, Inc 333 Luke Skywalker Oliver Queen Lightsaber, cred Price Luke Skywalker usaber, uc 1/10/2016 19 333 Luke Skywalker Oliver O Quart United Lense Clark Kent Quartz United 1/19/2016 586 Oliver Queen Bruce Wayne Houndsond. Custom Overen Houndould 1/15/2017 21 586 Oliver Queen Bruce Wayne Jameston Enterprises Wom Oliver Enterprises V12017 586 Oliver Queen Bruce Wayne TR stywie nerwood, Inc 1/11/2017 23 585 Oliver Queen Bruce Wayne Briarwood, TM leser Berwood, Inc 1/11/2017 14506 Central Road Metropolis Metropolis, 1123456 1456 Central Road Metropolis Metropolis, 123456 14565 Central Road Metropolis Metropole 23456 34566 Central Road Metropolis Metropolis 121456 566 Oliver Queen Brace Wayne wood recente ke Skywalker nerwood, in 1/11/2012 Queen 586 Oliver Bruce Wayne wood incense 1/11/2017 te staller Hierwood. In Question #7: Based on your 1NF table, in the space below, re-write the table so that it is in second normal form. You may add ID fields to any new tables you create and use those IDs as foreign keys in other tables as appropriate. (10 points) Question #8: What is the primary key of each of the 2NF tables you just constructed? Question #9: Identify the functional dependencies in the 2NF table(s) you constructed. Question #10: In the space below, re-write the 2NF table(s) so that they are in 3NF. Focus