The following table is un-normalized.

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.

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 1NF table you just constructed?

Question #3:

Identify the functional dependencies in the 1NF table you constructed.

Question #4:

Describe any insertion anomalies that can occur in your 1NF table.

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?

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 BCNF? Why or why not?

FirstLast EmplD Name Name Office Address Project Hours Date Worked 1/15/2018 8 1/16/2018 8 Office Supervisor Project Manager Client Arne, LLC-WO #1 Peter Parker Acme, LLC Oliver Queen Bruce Wayne 14566 Central Road Jameston Enterprises-WO #1 |Jameston Enterprises | 1/17/2018| 4 253 Peter Parkr Metropolis Metropolis, IL 23456 Bruce Wayne 1/18/2018 4 1/15/2018 8 1/16/20188 1/17/2018 8 1/18/2018 8 1/19/2018 8 1/15/20188 1/16/2018 4 1/17/2018 8 1/16/2018 4 1/15/20188 1/16/2018 8 1/17/2018 8 1/18/20188 1/19/2018 8 1/15/20174 Gatelle, Inc. - License Gatelle, Inc. 123 Oak Lane 987 Bruce Wayne Gotham Gotham, NY 45632 Quartz United - Software Upgrade Clark Kent Quartz United 14566 Central Road Acme, LLC-WO #2 Peter Parker Acme, Clark Kent Clark Kent Luke Skywalker Brierwood, Inc. 52 Clark Kent Metropolis Metropolis, IL 23456 Bruce Wayne Jones & Jones-WO #1 Jones & Jones Jones & Jones Jones &Jones - Maintenance Brierwood, Inc. - T&M 123 Oak Lane Lightsaber, LC-Fixed Price Luke Skywalker Lightsaber, LLC Clark Kent Oliver Queen Houndson, Ltd Oliver Queen Luke Skywalker Brierwood, Inc. 333 Luke Skywalker Gotham Gotham, NY 45632 liver Queen Quartz United - License Quartz United Houndson, Ltd. - Custom Jameston Enterprises-WO #1 Brierwood, Inc. - T&M |Jameston Enterprises | 1/15/2017 4 1/16/20174 1/17/2017 4 /16/2017 1/17/2017 4 14566 Central Road Brierwood, Inc. - License Luke Skywalker Brierwood, Inc. 586 Oliver ueeMetropolis Metropolis, IL 23456 Bruce Wayne