DB Engineering Testing Tables (without PK and FK)

USE dbi;

DROP TABLE IF EXISTS emp;
DROP TABLE IF EXISTS dept;
DROP TABLE IF EXISTS salgrade;


CREATE TABLE emp
(empNO DECIMAL(4),
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR DECIMAL(4),
HIREDATE DATE,
SAL DECIMAL(7, 2),
COMM DECIMAL(7, 2),
deptNO DECIMAL(2));

INSERT INTO emp VALUES (7369, 'Smith', 'Clerk', 7902, '1980-12-17',  800, NULL, 20);
INSERT INTO emp VALUES (7499, 'Allen', 'Salesman', 7698, '1981-02-20',  1600, 300, 30);
INSERT INTO emp VALUES (7521, 'Ward', 'Salesman', 7698, '1981-02-22',  1250, 500, 30);
INSERT INTO emp VALUES (7566, 'Jones', 'Manager', 7839, '1981-04-02',  2975, NULL, 20);
INSERT INTO emp VALUES (7654, 'Martin', 'Salesman', 7698, '1981-09-28',  1250, 1400, 30);
INSERT INTO emp VALUES (7698, 'Blake', 'Manager', 7839, '1981-05-01',  2850, NULL, 30);
INSERT INTO emp VALUES (7782, 'Clark', 'Manager', 7839, '1981-06-09',  2450, NULL, 10);
INSERT INTO emp VALUES (7788, 'Scott', 'Analyst', 7566, '1982-12-09',  3000, NULL, 20);
INSERT INTO emp VALUES (7839, 'King', 'President', NULL, '1981-11-17',  5000, NULL, 10);
INSERT INTO emp VALUES (7844, 'Turner', 'Salesman', 7698, '1981-09-08',  1500, 0, 30);
INSERT INTO emp VALUES (7876, 'Adams', 'Clerk', 7788, '1983-01-12',  1100, NULL, 20);
INSERT INTO emp VALUES (7900, 'James', 'Clerk', 7698, '1981-12-03',  950, NULL, 30);
INSERT INTO emp VALUES (7902, 'Ford', 'Analyst', 7566,'1981-12-03',  3000, NULL, 20);
INSERT INTO emp VALUES (7934, 'Miller', 'Clerk', 7782,'1982-01-23',  1300, NULL, 10);
INSERT INTO emp VALUES (1337, '83n3d1X7__', 'Nerd', NULL,'1970-01-01',  666, NULL, NULL);

CREATE TABLE dept
(deptNO DECIMAL(2),
DNAME VARCHAR(14),
LOC VARCHAR(13) );

INSERT INTO dept VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO dept VALUES (20, 'RESEARCH', 'DALLAS');
INSERT INTO dept VALUES (30, 'SALES', 'CHICAGO');
INSERT INTO dept VALUES (40, 'OPERATIONS', 'BOSTON');

CREATE TABLE salgrade
(GRADE DECIMAL,
LOSAL DECIMAL,
HISAL DECIMAL);

INSERT INTO salgrade VALUES (1, 700, 1200);
INSERT INTO salgrade VALUES (2, 1201, 1400);
INSERT INTO salgrade VALUES (3, 1401, 2000);
INSERT INTO salgrade VALUES (4, 2001, 3000);
INSERT INTO salgrade VALUES (5, 3001, 9999);