-- Drop existing tables. Will fail if tables don't exist.
-- DROP TABLE DEPT;
-- DROP TABLE EMP;

-- Create table DEPT
CREATE TABLE DEPT(
DEPTNO  VARCHAR(3),
DEPTNAME  VARCHAR(28),
MGRNO  VARCHAR(6),
ADMRDEPT  VARCHAR(3),
LOCATION  VARCHAR(5)  
);

-- Create the table EMP
CREATE TABLE EMP
(EMPNO  INTEGER,
FIRSTNME  VARCHAR(9),
MIDINIT  VARCHAR(1),
LASTNAME  VARCHAR(10),
WORKDEPT  VARCHAR(3),
PHONENO  VARCHAR(4),
HIREDATE  DATE,
JOB  VARCHAR(8),
EDLEVEL  SMALLINT,
SEX  VARCHAR(1),
BIRTHDATE  DATE,
SALARY  DECIMAL(10,2),
BONUS  DECIMAL(8,2),
COMM  DECIMAL(8,2)
);