drop database ecst_employee;
CREATE DATABASE ecst_employee;
USE ecst_employee;

drop table if exists Employee;


CREATE TABLE Employee (
	EmployeeID int PRIMARY KEY ,
	FirstName varchar (50) NOT NULL ,
	LastName varchar (50) NOT NULL ,
	JobTitle varchar (50) NOT NULL ,
	Salary decimal NULL ,
	SupervisorID int NULL	
);



Insert Into Employee Values(1,'Emily','Allen','Dean',25,NULL);
Insert Into Employee Values(2,'Raj','Pamula','Department Chair',20,1);
Insert Into Employee Values(3,'Chengyu','Sun','Assistant Professor',15,2);
Insert Into Employee Values(4,'Russell','Abbott','Professor',25,2);
Insert Into Employee Values(5,'Huiping','Guo','Assistant Professor',15,2);
Insert Into Employee Values(6,'Tarik','Booker','Teaching Associate',1,2);
Insert Into Employee Values(7,'John','Hurley','Teaching Associate',1,2);