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) * MY 1NF based on the one above has all the same info in single lines, so the 1st row is broken down into 4 rows and so on.

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?

CSIS 325 Lab 7 Normalization 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. First Last Office Project Hours Emplo Name Name Office Address Supervisor Project Manager Client Date Worked Acme, LLC - WO #1 - Peter Parker Acme, LLC 1/15/2018 8 1/16/2018 8 14566 Central Road Jameston Enterprises - WO #1 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 8 123 Oak Lane 1/18/2018 8 987 Bruce Wayne Gotham Gotham, NY 45632 1/19/2018 8 Wochote Quartz United - Software Upgrade Clark Kent Quartz United 1/15/2018 8 1/16/2018 4 . 14566 Central Road Acme, LLC - WO #2 Peter Parker Acme, LLC 1/17/2018 8 52 Clark Kent Metropolis Metropolis, IL 23456 Bruce Wayne Jones & Jones - WO #1 Clark Kent Jones & Jones & 1/16/2018 4 Jones & Jones - Maintenance Clark Kent Jones & Jones 1/15/2018 8 Brierwood, Inc. - T&M Luke Skywalker Brierwood, Inc. 1/16/2018 8 1/17/2018 8 123 Oak Lane Lightsaber, LLC - Fixed Price Luke Skywalker Lightsaber, LLC 1/18/2018 8 333 Luke Skywalker Gotham Gotham, NY 45632 Oliver Queen Quartz United - License Quartz United 1/19/2018 8 Houndson, Ltd. - Custom Oliver Queen Houndson, Ltd. 1/15/2017 4 1 Jameston Enterprises - WO #1 Oliver Queen Jameston Enterprises 1/15/2017 4 4 Brierwood, Inc. - T&M Luke Skywalker Brierwood, Inc. 1/16/2017 4 1/17/2017 4 14566 Central Road Brierwood, Inc. - License Luke Skywalker Brierwood, Inc. 1/16/2017 4 586 Oliver Queen Metropolis Metropolis, IL 23456 Bruce Wayne 1/17/2017 4 Clark Kent