CREATE TABLE EMP(EmpNo INTEGER(4), DeptNo INTEGER(2), EmpName CHAR(10), Job CHAR(10), Manager INTEGER(4), HireDate DATE, Salary DECIMAL(7,2), Commission DECIMAL(7,2));
CREATE TABLE PROJECT(ProjId INTEGER(4), ProjDesign CHAR(20), ProjStartDT DATE, ProjEndDT DATE, BudgetAmount INTEGER(7), MaxNoStaff INTEGER(2));
CREATE TABLE DEPT(DeptNo INTEGER(2), DeptName CHAR(12), Location CHAR(12));