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

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.

The following table is un-normalized. The original data set is in the

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 Project Office Address Hours Date Worked 1/15/2018 8 1/16/20188 EmplD Name Name Office Supervisor Project Manager Client Acme, LLC-WO #1 Jameston Enterprises-WO #1 Gatelle, Inc. - License Peter Parker Acme, LLC Oliver Queen Bruce Wayne 14566 Central Road Jameston Enterprises | 1/17/2018| 4 253 Peter Parker Metropolis Metropolis, IL 23456 Bruce Wayne 1/18/2018 4 1/15/2018 8 1/16/2018 8 1/17/2018 8 1/18/2018 8 1/19/2018 1/15/20188 1/16/20184 1/17/2018 8 1/16/2018 4 1/15/20188 1/16/2018 8 1/17/2018 8 1/18/20188 1/19/20188 /15/2017 Gatelle, Inc. 123 Oak Lane 987 Bruce Wayne Gotham Gotham, NY 45632 Quartz United-Software Upgrade Clark Kent Quartz United 14566 Central Road Peter Parker Acme, LLC 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, LLC- 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 Oliver 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 1/16/20174 1/17/2017 4 14566 Central Road Brierwood, Inc. -License Luke Skywalker Brierwood, Inc. 586 Oliver eeMetropolis Metropolis, IL 23456 Bruce Wayne FirstLast Project Office Address Hours Date Worked 1/15/2018 8 1/16/20188 EmplD Name Name Office Supervisor Project Manager Client Acme, LLC-WO #1 Jameston Enterprises-WO #1 Gatelle, Inc. - License Peter Parker Acme, LLC Oliver Queen Bruce Wayne 14566 Central Road Jameston Enterprises | 1/17/2018| 4 253 Peter Parker Metropolis Metropolis, IL 23456 Bruce Wayne 1/18/2018 4 1/15/2018 8 1/16/2018 8 1/17/2018 8 1/18/2018 8 1/19/2018 1/15/20188 1/16/20184 1/17/2018 8 1/16/2018 4 1/15/20188 1/16/2018 8 1/17/2018 8 1/18/20188 1/19/20188 /15/2017 Gatelle, Inc. 123 Oak Lane 987 Bruce Wayne Gotham Gotham, NY 45632 Quartz United-Software Upgrade Clark Kent Quartz United 14566 Central Road Peter Parker Acme, LLC 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, LLC- 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 Oliver 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 1/16/20174 1/17/2017 4 14566 Central Road Brierwood, Inc. -License Luke Skywalker Brierwood, Inc. 586 Oliver eeMetropolis Metropolis, IL 23456 Bruce Wayne

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

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

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

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

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

PSYC 355 LAB PROJECT OVERVIEW AND INSTRUCTIONS It is very important that students of statistics know how to choose the correct analysis for a given research question, collect the data, run the test,...

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

What specific principles for conduct can be used to guide ethical decisions? 1. List and describe the five steps in an ethical analysis. 2. Identify and describe six ethical principles.

Assume Company Wolverine has the following information: After tax cost of debt = 5.0%. Cost of Equity = 12.0% Capital structure = 40% debt, 60% equity. What is the Weighted Average Cost of Capital...

Which of the following is not a common attack against RADIUS

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

2. Why do people volunteer for non-profit-making organisations and what can these organisations do to ensure their volunteers are engaged?

4. What volunteering have you done and why did you volunteer? If you havent volunteered for anything, why havent you?

2. Explain the relationship between employee involvement, employee commitment, engagement and high-performance working.