Question: 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

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

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. st impoName Name . 4 253 Peter Parker Otae Project How Offe Address Supervisor Prolet Manager Client Date Worlat Am UcWO #1 Piter Parker Acme, ur 1/15/2011 1/10/2016 1456 Central Road Jameston Enterprises. WO 1 Cover Cuen Lameston Enterprises 1/17/2016 Metropolis Metropol IL 2.1456 bruce wame 1/11/2018 catele, ingens Bruce Wayne catenc 1/11/2018 1/10/2018 V17/2018 123 Oak Lane 1/11/2016 B citam Gotham NY 45832 1/19/ Quartz United software Upgrade darkent Quarte Unted 1/15/2018 3 1/11/2016 1456 Central Road Am C WOR2 Peter Parker Acme, C 1/17/2018 Metropol Metropol L 23656bruce Waynelione & Jonewo Clarket nelones 1/15/2018 one ontMantanice Dark Kent one ones 1/15/2016 Brenvooding.TEM Laderlorerwood, 97 Way 52 dark kunt SSSS 133 ORU dom NY 45833 333 Luke wake otram Litbec Pod Phoe Oliver Queen lauart: United Hounds, custom estos Enterprises. WOR1 Brent HTAM Luke Skywater ushtaber, LLC Clark Kent Quartz United olver Queen nondonid over a ceston Enterprise Le Sewaker Berwood, in BE SSSS le sywalker wood. In 148 Gintamod Intense Metro2450 Wame 1/10/2017 11/17/21 566 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. 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 BNF 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? Emplo Name Name Office Address Supervisor Project Manager Client Dor Wow Acme, LLC-WOW1 Peter Parker Acme, uc 1/15/2018 8 1/16/2018 3 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 Gatele, Inc. - Ekense Bruce Wayne Gatelle, Inc. 1/15/2018 8 1/16/2018 8 1/17/2018 8 122 Oaklane 1/18/2018 8 987 Bruce Wayne Gotham Gotham, NY 45632 1/19/2018 Quartz United Software Upgrade Clark Kent Quartz United 1/15/2018 1/16/2018 4 14566 Central Road Acme, LLC WO 2 Peter Parker Acme, LLC 1/17/2018 52 clark Kent Clark Kent Metropolis Metropolis, IL 23456 Bruce Wayne Jones & Jones Wom Jones & Jones 4 1/10/2018 Jones & Jones Maintenance Clark Kent Jones & Bones 1/15/2018 Browood, Inc. - T&M Luke Skywalker Berwood, Inc. 1/16/2018 1/17/2018 Lightsaber, LLC - Fixed Price 123 Oak Lane 1/18/2018 Luke Skywalker Lightsaber, LLC 1/19/2010 Clark Kent Gotham, NY 45632 Quart United Oliver Queen Quart United - License 333 Luke Skywalker Gotham 4 Houndson, Ltd. - Custom Oliver Queen 1/15/2017 Houndson, Ltd. Jameston Enterprises - WOW Oliver Queen Jameston Enterprises 1/15/2017 Brierwood, Inc. - T&M 1/16/2017 Luke Skywalker Brlerwood, Inc. 1/17/2017 1/16/2017 Luke Skywalker Brienwood, Inc. 14566 Central Road arierwood, Inc. - License 1/17/2017 586 Oliver Queen Metropolis Metropolis, IL 23456 Bruce Wayne re

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

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...

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...

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 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...

Audit Action Sheet 1: Suspicious Suppliers Risk: Medium Auditor: Date Performed: Rating: 0 1 2 3 4 Comments/Observations: Policy: Employees should not also be related to suppliers, except where...

Can you please please assist me with the below. Thank you so much in advance. I need to make a sheet with the below data. The question is that needs to be answered is in the green picture that was...

ICTN4310 LAB 03 - DATA ACQUISITION Background. Whether you are formatting an internal drive, external drive, USB flash drive, or SD card, Windows gives you the choice of using three different file...

Before beginning this lab, run the following script in the SQL Server query window. If you have already created a database called hourglass, be sure to drop the database before running these queries....

Description The assignment requires that you analyse a data set, interpret, and draw conclusions from your analysis, and then convey your conclusions in a written report. The assignment must be...

Write a paper on Evaluation of a Hypothetical Situation

Austin Clinic deposits all cash receipts on the day when they are received and it makes all cash payments by check. At the close of business on June 30, 2011, its Cash account shows an $15,671 debit...

For every dollar of operating income paid out as interest, the bondholder realizes: ( T C = corporate tax rate ; T p E = personal tax rate on equity income ; and T p = personal tax rate on interest...

Which of the following impacts stockholders' equity but does not impact retained earnings? Group of answer choices recording a net loss for the fiscal year recording a net profit for the fiscal year...

14-2 What methods can be used for selecting and evaluating information systems projects and aligning them with the firms business goals?

14-3 How can firms assess the business value of information systems?

14-1 What are the objectives of project management, and why is it so essential in developing information systems?