Proj_Name	Proj_Mgr	Emp_Id	Hours	Proj_Budget	Start_Date	Emp_Salary	Emp_manager	Emp_Dept	Rating
Jupiter	Smith	E101	25	100000	1/15/2015	60000	Levine	10	9
Jupiter	Smith	E105	40	100000	1/15/2015	55000	Jones	12
Jupiter	Smith	E110	10	100000	1/15/2015	43000	Levine	10	8
Maxima	Lee	E101	15	200000	3/1/2014	60000	Levine	10
Maxima	Lee	E110	30	200000	3/1/2014	43000	Levine	10
Maxima	Lee	E120	15	200000	3/1/2014	45000	Jones	15

On the top onginal data follows

I transform tp (3NF) nomalization bellow and i need help create for each table primary keys and foreign keys.

and part 3 and part 4 all the sql query.

Employee

Employee_ID	Emp_Salary
E101	60000
E105	55000
E110	43000
E101	60000
E110	43000
E120	45000

Project

Project_Name	Project_Manager	Proj_Buget	Proj_StartDay
Jupiter	Smith	1000000	1/15/2015
Maxima	Lee	2000000	3/1/2014

Department

Emp_Department	Emp_Manager
10	Levine
12	Jones
15	Jones

Payment

Proj_Name	Emp_Id	Hours	Salary	Rating
Jupiter	E101	25	60000	9
Jupiter	E105	40	55000
Jupiter	E110	10	43000	8
Maxima	E101	15	60000
Maxima	E 110	30	43000
Maxima	E120	15	45000

Part 03

Write an SQL query to select the data that are shown in the table of part 01.

Part 04

Update the employee records and give a 1000$ increase to the employees of department 10.

Insert a new column that will hold the project estimated end date.

Update this column to set the values to:

Jupiter: 01/01/2016

Maxima: 03/15/17

Change the name of the column that holds the employee id to EMP_NUMBER

Delete project Maxima

Truncate the table that holds the manager information.

Drop the column that holds the employee project ratings.

Insert a new employee with and empty salary (Choose values for the rest of the columns)

Drop the table that holds the manager information.