CREATE DATABASE MY_BUSINESS

CREATE TABLE DEPT ( 
DEPTNO NUMERIC(2) NOT NULL,
DNAME CHAR(14),
LOC CHAR(13))

CREATE TABLE EMP (
EMPNO NUMERIC(4) NOT NULL,
ENAME CHAR(10),
JOB CHAR(9),
MGR NUMERIC(4),
HIREDATE DATETIME,
SUL NUMERIC(7,2),
COMM NUMERIC(7,2),
DEPTNO NUMERIC(2))

CREATE TABLE BONUS (
ENAME CHAR(10),
JOB CHAR(9),
SAL NUMERIC,
COMM NUMERIC)

CREATE TABLE SALGRADE(
GRADE NUMERIC,
LOSAL NUMERIC,
HISAL NUMERIC)

CREATE TABLE CUSTOMER (
ZIP CHAR(9),
STATE CHAR(2),
REPID NUMERIC(4) NOT NULL,
PHONE CHAR(9),
NAME CHAR(45),
CUSTID NUMERIC(6) NOT NULL,
CREDITLIMIT NUMERIC (9,2),
CITY CHAR(30),
AREA NUMERIC(3),
ADDRESS CHAR(40),
COMMENTS TEXT)

CREATE TABLE ORD (
TOTAL NUMERIC (8,2),
SHIPDATE DATETIME,
ORDID NUMERIC(4) NOT NULL,
ORDERDATE DATETIME,
CUSTID NUMERIC (6) NOT NULL,
COMMPLAN CHAR(1))

CREATE TABLE ITEM (
QTY NUMERIC (8),
PRODID NUMERIC(6),
ORDID NUMERIC(4) NOT NULL,
ITEMTOT NUMERIC (8,2),
ITEMID NUMERIC(4) NOT NULL,
ACTUALPRICE NUMERIC (8,2))

CREATE TABLE PRODUCT (
PRODID NUMERIC (6),
DESCRIP NUMERIC (30))

CREATE TABLE PRICE (
STDPRICE NUMERIC (8,2),
STARTDATE DATETIME,
PRODID NUMERIC (6) NOT NULL,
MINPRICE NUMERIC (8,2),
ENDDATE DATETIME)

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

INSERT INTO EMP VALUES 

(7839,'KING','PRESIDENT',NULL,'17-NOV-81',5000,N

ULL,10);
INSERT INTO EMP VALUES 

(7698,'BLAKE','MANAGER',7839, '1-MAY-81', 2850, 

NULL, 30);
INSERT INTO EMP VALUES (7782, 'CLARK', 

'MANAGER', 7839, '9-JUN-81', 2450, NULL, 10);
INSERT INTO EMP VALUES (7566 ,'JONES' 

,'MANAGER', 7839, '2-APR-81', 2975, NULL, 20);
INSERT INTO EMP VALUES (7654,' MARTIN' 

,'SALESMAN', 7698, '28-SEP-81', 1250, 1400, 30);
INSERT INTO EMP VALUES (7499, 'ALLEN', 

'SALESMAN', 7698, '20-FEB-81', 1600, 300, 30);
INSERT INTO EMP VALUES (7844, 'TURNER', 

'SALESMAN', 7698, '8-SEP-81', 1500, 0, 30);
INSERT INTO EMP VALUES (7900, 'JAMES', 

'CLERK', 7698, '3-DEC-81', 950, NULL, 30);
INSERT INTO EMP VALUES (7521, 'WARD', 

'SALESMAN', 7698, '22-FEB-81', 1250, 500, 30);
INSERT INTO EMP VALUES (7902, 'FORD', 

'ANALYST', 7566, '3-DEC-81', 3000, NULL, 20);
INSERT INTO EMP VALUES (7369, 'SMITH', 

'CLERK', 7902, '17-DEC-80', 800, NULL, 20);
INSERT INTO EMP VALUES (7788, 'SCOTT', 

'ANALYST', 7566, '09-DEC-82', 3000, NULL, 20);
INSERT INTO EMP VALUES (7876, 'ADAMS', 

'CLERK', 7788, '12-JAN-83', 1100, NULL, 20);
INSERT INTO EMP VALUES (7934, 'MILLER', 

'CLERK', 7782, '23-JAN-82', 1300, NULL, 10);


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