CREATE TABLE Bk_employees
(
E_Id int PRIMARY KEY,
Manager_ID Int,
Department_ID Number,
First_Name varchar(255),
Last_Name varchar(255),
Email varchar(255),
Phone_Number Number,
Hire_Date Date,
Job_id Int,
Salary Number,
FOREIGN KEY (Job_ID) REFERENCES BK_Jobs(Job_ID)
);
INSERT INTO Bk_Employees (E_Id,Manager_ID,Department_ID,First_Name,Last_Name,Email,Phone_Number,Hire_Date,Job_id)
VALUES('4001','4003','2001','Bryson','K','bryson.kambole@imbasa.co.za','0782743385','06.06.2015','3001')