Question: In the space below, re-write the 2NF table(s) so that they are in 3NF. Employee Table EmpID First Name Last Name Office Supervisor 253 Peter

In the space below, re-write the 2NF table(s) so that they are in 3NF.

Employee Table

EmpID

First Name

Last Name

Office

Supervisor

253

Peter

Parker

Metropolis

Bruce Wayne

987

Bruce

Wayne

Gotham

52

Clark

Kent

Metropolis

Bruce Wayne

333

Luke

Skywalker

Gotham

Oliver Queen

586

Oliver

Queen

Metropolis

Bruce Wayne

Project Table

ProjectID

EmpID

Project

Project Manager

1

253

Acme, LLC - WO #1

Peter Parker

2

253

Jameston Enterprises - WO #1

Oliver Queen

3

987

Gatelle, Inc. - License

Bruce Wayne

4

52

Quartz United - Software Upgrade

Clark Kent

5

52

Acme, LLC - WO #2

Peter Parker

6

52

Jones & Jones - WO #1

Clark Kent

7

333

Jones & Jones - Maintenance

Clark Kent

8

333

Brierwood, Inc. - T&M

Luke Skywalker

9

333

Lightsaber, LLC - Fixed Price

Luke Skywalker

10

333

Quartz United - License

Clark Kent

11

586

Houndson, Ltd. - Custom

Oliver Queen

12

586

Jameston Enterprises - WO #1

Oliver Queen

13

586

Brierwood, Inc. - T&M

Luke Skywalker

14

586

Brierwood, Inc. - License

Luke Skywalker

Date Table

DateID

ProjectID

Date

Hours Worked

1

1

1/15/2018

8

2

1

1/16/2018

8

3

2

1/17/2018

4

4

2

1/18/2018

4

5

3

1/15/2018

8

6

3

1/16/2018

8

7

3

1/17/2018

8

8

3

1/18/2018

8

9

3

1/18/2018

8

10

4

1/15/2018

8

11

4

1/16/2018

4

12

5

1/17/2018

8

13

6

1/16/2018

4

14

7

1/15/2018

8

15

8

1/16/2018

8

16

8

1/17/2018

8

17

9

1/18/2018

8

18

10

1/19/2018

8

19

11

1/15/2017

4

20

12

1/15/2017

4

21

13

1/16/2017

4

22

13

1/17/2017

4

23

14

1/16/2017

4

24

14

1/17/2017

4

Office Table

Office

Office Address

Metropolis

14566 Central Road

Metropolis, IL 23456

Gotham

123 Oak Lane

Gotham, NY 45632

Project Manager Table

Project Manager

Client

Peter Parker

Acme, LLC

Oliver Queen

Jameston Enterprises

Bruce Wayne

Gatelle, Inc.

Clark Kent

Quartz Unlimited

Luke Skywalker

Brierwood, Inc.

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?

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!

Q:

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

Q:

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

Q:

Can someone explain how to make this table into 1NF, 2NF, and 3NF?? 2 3 5 Last 1 EmpIC Na Name Office 6 7 8 9 A 10 B Firs C D 52 Clark Kent 253 Peter Parker Metropoli 23456 Office Address 586 Oliver...

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

Database: ACTUAL DATA - Data for ConferenceDB -- BUILDING (Id, Name) DROP TABLE IF EXISTS `BUILDING`; CREATE TABLE `BUILDING`( Id INT, Name VARCHAR(20), PRIMARY KEY (Id) )ENGINE = InnoDB; INSERT INTO...

Q:

An individual may invest in stocks either directly or through a mutual fund. How are the two investment methods different?

Q:

You have been employed at a state agency for 15 years. You started in a customer service call center, moved your way up to project coordinator, then project manager, and today you are a division...

Q:

3. IFRS permits the use of fair value accounting for property and plant assets. Why, then, do most companies prefer to use historical (or acquisition) cost?

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

What are Decision Trees?

Q:

What is meant by the Term Glass Ceiling?

Q:

What Interface is used to develop Data Mining Structures in SQL Server Analytical Databases?