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?