/*Create database t1911*/

/*
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),
 HIDERATE 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,2),
 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),
 DESCR	CHAR	(30))

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