CREATE DATABASE MY_BUSINESS


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



CREATE TABLE EMP (
EMPNO NUMERIC(2) 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 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),
PODID 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 CHAR(30),)



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