rendered paste bodyhttp://pastebin.ca/737331
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,
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)
http://pastebin.ca/729782
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, NULL, 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);
INSERT INTO CUSTOMER VALUES ('96711', 'CA', 7844, '598-6609', 'JOCKSPORTS', 100, 5000, 'BELMONT', 415, '345 VIEWRIDGE', 'Very friendly
people to work with -- sales rep likes to be called Mike.');
INSERT INTO CUSTOMER VALUES ('94061', 'CA', 7521, '368-1223', 'TKB SPORT SHOP', 101, 10000, 'REDWOOD CITY', 415, '490 BOLI RD.', 'Rep
called 5/8 about change in order - contact shipping.');
INSERT INTO CUSTOMER VALUES ('95133', 'CA', 7654, '644-3341', 'VOLLYRITE', 102, 7000, 'BURLINGAME', 415, '9722 HAMILTON', 'Company
doing heavy promotion beginning 10/89. Prepare for large orders during winter.');
INSERT INTO CUSTOMER VALUES ('97544', 'CA', 7521, '677-9312', 'JUST TENNIS', 103, 3000, 'BURLINGAME', 415, 'HILLVIEW MALL', 'Contact
rep about new line of tennis rackets');
INSERT INTO CUSTOMER VALUES ('93301', 'CA', 7499, '996-2323', 'EVERY MOUNTAIN', 104, 10000, 'CUPERTINO', 406, '574 SURRY RD.',
'Customer with high market share (23%) due to aggressive advertising.');
INSERT INTO CUSTOMER VALUES ('91003', 'CA', 7844, '376-9966', 'K + T SPORTS', 105, 5000, 'SANTA CLARA', 408, '3476 EL PASEO', 'Tends to
order large amounts of merchandise at once. Accounting is considering');
INSERT INTO ORD VALUES (101.4, '08-JAN-87', 610, '07-JAN-87', 101, 'A');
INSERT INTO ORD VALUES (45, '11-JAN-87', 611, '11-JAN-87', 102, 'B');
INSERT INTO ORD VALUES (5860, '20-JAN-87', 612, '15-JAN-87', 104, 'C');
INSERT INTO ORD VALUES (2.4, '30-MAY-86', 601, '01-MAY-86', 106, 'A');
INSERT INTO ORD VALUES (56, '20-JUN-86', 602, '05-JUN-86', 102, 'B');
INSERT INTO ORD VALUES (698, '30-JUN-86', 604, '15-JUN-86', 106, 'A');
INSERT INTO ORD VALUES (8324, '30-JUL-86', 605, '14-JUL-86', 106, 'A');
INSERT INTO ORD VALUES (3.4, '30-JUL-86', 606, '14-JUL-86', 100, 'A');
INSERT INTO ORD VALUES (97.5, '15-AUG-86', 609, '01-AUG-86', 100, 'B');
INSERT INTO ORD VALUES (5.6, '18-JUL-86', 607, '18-JUL-86', 104, 'C');
INSERT INTO ITEM VALUES (1, 100890, 610, 58, 3, 58);
INSERT INTO ITEM VALUES (1, 100861, 611, 45, 1, 45);
INSERT INTO ITEM VALUES (100, 100860, 612, 3000, 1, 30);
INSERT INTO ITEM VALUES (1, 200376, 601, 2.4, 1, 2.4);
INSERT INTO ITEM VALUES (20, 100870, 602, 56, 1, 2.8);
INSERT INTO ITEM VALUES (3, 100890, 604, 174, 1, 58);
INSERT INTO ITEM VALUES (2, 100861, 604, 84, 2, 42);
INSERT INTO ITEM VALUES (10, 100860, 604, 440, 3, 44);
INSERT INTO ITEM VALUES (4, 100860, 603, 224, 2, 56);
INSERT INTO ITEM VALUES (1, 100860, 610, 35, 1, 35);
INSERT INTO ITEM VALUES (3, 100870, 610, 8.4, 2, 2.8);
INSERT INTO ITEM VALUES (200, 200876, 613, 440, 4, 2.2);
INSERT INTO ITEM VALUES (444, 100860, 614, 15540, 1, 35);
INSERT INTO ITEM VALUES (1000, 100870, 614, 2800, 2, 2.8);
INSERT INTO ITEM VALUES (20, 100861, 612, 810, 2, 40.5);
INSERT INTO PRODUCT VALUES (100860, 'ACE TENNIS RACKET I');
INSERT INTO PRODUCT VALUES (100861, 'ACE TENNIS RACKET II');
INSERT INTO PRODUCT VALUES (100870, 'ACE TENNIS BALLS-3 PACK');
INSERT INTO PRODUCT VALUES (100871, 'ACE TENNIS BALLS-6 PACK');
INSERT INTO PRODUCT VALUES (100890, 'ACE TENNIS NET');
INSERT INTO PRODUCT VALUES (101860, 'SP TENNIS RACKET');
INSERT INTO PRODUCT VALUES (101860, 'SP JUNIOR RACKET');
INSERT INTO PRICE VALUES (4.8, '01-JAN-85', 100871, 3.2, '01-DEC-85');
INSERT INTO PRICE VALUES (58, '01-JAN-85', 100890, 46.4, '');
INSERT INTO PRICE VALUES (54, '01-JUN-84', 100890, 40.5, '31-MAY-84');
INSERT INTO PRICE VALUES (35, '01-JUN-86', 100860, 28, '');
INSERT INTO PRICE VALUES (32, '01-JAN-86', 100860, 25.6, '31-MAY-86');
INSERT INTO PRICE VALUES (30, '01-JAN-85', 100860, 24, '31-DEC-85');
INSERT INTO PRICE VALUES (45, '01-JUN-86', 100861, 36, '');
INSERT INTO PRICE VALUES (42, '01-JAN-86', 100861, 33.6, '31-MAY-86');
INSERT INTO PRICE VALUES (2.8, '01-JAN-86', 100870, 2.4, '');
INSERT INTO PRICE VALUES (12.5, '15-FEB-85', 101863, 9.4, '');
INSERT INTO PRICE VALUES (2.4, '15-NOV-86', 200376, 1.75, '');