CREATE DATABASE MY_BUSINESS

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

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

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

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

CREATE TABLE CUSTAMER(
	ZIP CHAR (9),
	STATE CHAR (2),
	REDIP 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,
	ORDIT 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),
	DESCRIPT CHAR (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')