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);