Office Project Empin Name Name Office Address Supervisor Projed Manager Client Bate Worked Acme, uc - Wom Peter Parker Acme, LLC 1/15/2018 8 1/16/2018 8 14566 Central Road Jameston Enterprises - Wom Oliver Queen Jameston Enterprises 1/17/2018 4 253 Peter Parker Metropolis Metropolis, IL 23456 Bruce Wayne 1/18/2018 4 Gatelle, Inc. License Bruce Wayne Gatelle, Inc. 1/15/2018 8 1/16/2018 8 1/17/2018 B 123 Oak Lane 1/10/2018 B 987 Bruce Wayne Gotham Gotham, NY 45632 1/19/2018 3 Quartz United - Software Upgrade clark Kent Quartz United 1/15/2018 B 1/16/2018 4 14566 Central Road Acme, LLC - WON2 Peter Parker Acme, LLC 1/17/2018 B S2 Clark Kent Clark Kent Metropolis Metropolis, IL 23456 Bruce Wayne Jones & Jones - WoW Jones & Jones 4 1/16/2018 lones & Jones Maintenance Clark Kent lones & Jones 1/15/2018 8 Brierwood, Inc. - T&M Luke Skywalker Brierwood, Inc. 1/10/2018 8 1/17/2018 123 Oak Lane Lightsaber, LLC - Fixed Price Luke Skywalker ughtsaber, LLC 1/18/2018 333 Luke Skywalker Gotham Gotham, NY 45632 Oliver Queen Quartz United - License Clark Kent Quartt United 1/19/2018 Houndson, Ltd. - Custom Oliver Queen Houndson, Ltd. 1/15/2017 Jameston Enterprises - WOW Oliver Queen Jameston Enterprises 1/15/2017 Brierwood, Inc. - T&M Luke Skywalker Brierwood, Inc. 1/16/2017 1/17/2017 14566 Central Road Brierwood, Inc. - Ucense Luke Skywalker Brierwood, Inc. 1/16/2017 1/17/2017 586 Oliver Queen Metropolis Metropolis, IL 23456 Bruce Wayne Focus Question #5: Describe any deletion anomalies that can occur in your 1NF table. Question #6: Describe any modification anomalies that can occur in your 1NF table. 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? GRIE GER TEN 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. F Office Project Hos Ampio Name Name Office Address Supervisor Project MARI Client Date Worked Acme, uc.WO Peter Parker Acme, LLC 115/2018 8 1/16/2018 8 14566 Central Road Lameton Enterprises-WONI Oliver Queen Jameston Enterprise 117/2018 14 Ser Parker Metropolis Metropolis, ... 2166 Bruce Wayne V 18/2018 4 Gatelle, Inc. - License Bruce Wayne Gatelle, Inc. V15/2018 8 116/2018 V17/2018 1230 Lane VLA2018 Bruce Wayne Gotham Gotham NY 45632 V 19 2018 Quan United Software Upgraderen Quanta United VASA018 V 16/2018 1.456 Canal Road Atme, WO #2 Peter Parker Am uc 112/2018 Kent Metro Metropolis, IL 23456 Bruce Waynenes ones.WORE Car Rent lons & Jones 1/16/2018 llones Jones Maine Kent nes 120L DewoodTM Le Skywalkerwand 1/16/2018 1/27/2018 12 hidro uke Skywall dia th de NV2 Que Quarte 2018 | 0 12 Vit | | | | | be on W wa USA Siwalewood 1/10/2017 IMAW2012 teade Leerweg 1/10/2012 Membre 7301? LORER Question 1 In the space below, re write the table above so that it is in first normal form. Question #2 What is the primary key of the INF table you just constructed? Question #3 Identify the functional dependencies in the INF table you constructed. Question 4 Describe any insertion anomalies that can occur in your 1NF table
