The following table is un-normalized, 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. 5 D Arst Last office Project Name Empt Name office Address Supervar Project Manager Clent Date Wort Am uc-WO1 Peter Parker Acme, uc 1/15/2018 16/18 14556 Central Road Jameston Enterprises-WORL olver Queen ameston Enterprises 1/17/2018 253 Peter Parker Metropolis Metropolis, IL 23456 Bruce Wayne 1/2018 Gatelle, Inc. - Ukense Bruce Wayne Gatele, ne 1/15/2018 1/16/2016 117/2018 123 Oak Lane 1/1/2018 987 Bruce Wayne Gotham Gotham, NY 45832 11/19/2018 Quartz United-Software Upgrade Clark Kent Quartz Urvited 125/2013 1/16/2018 14966 Central Road Acme LLC - WOW Peter Parker Acme, uc 1/17/2018 52 Clark Kent Metropolis Metropolis, IL 23456 Bruce Wayne Jones Jones-Wom Clark Kent Jones & Jones 1/16/2018 Jones & Jones - Maintenance Clark Kent Jones & Jones 1/15/2018 B Brenwood, Inc. - T&M Luke Skorwalker Brierwood in 1/16/2016 1/17/2018 123 Oak Lane Lightsaber LLC - Fixed Pince Luke Skywalker Lightsaber. 1/28/2018 Gotham, NY 45832 Clarkent olver Queen Quartz United - License Quartz United 333 Luke Skywalker Gotham 1/19/2018 Houndson Ltd. - Custom Oliver Queen Houndson, Ltd. 1/15/2017 smestion Enterprises - WO 1 olver Queen Jameston Enterprises. 1/25/2012 Briarwood, inc. - T&M Luke Skywalkererwood, ind 1/15/2017 1/17/2017 1/16/2017 14966 Central Road LUR Skywalker Brienwood, in Brood inc. - License 1/17/2017 4 556 Oliver Queen Metropol Metropolis, IL 23458 Bruce Wayne . TE LIELILI 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. Question #11: What is the primary key of each of the 3NF tables you just constructed? Question #12: Identify the functional dependencies in the 3NF table(s) you constructed. Question #13: Are all of your tables in BCNE? Why or why not