REM
REM $Header: bdemobld.sql 1.1 94/10/19 09:22:46 gdudey Osd<desktop/netware> $ Copyr (c) 1994 Oracle
REM
DROP TABLE ITEM;
DROP TABLE SALES_ORDER;
DROP TABLE CUSTOMER;
DROP TABLE PRICE;
DROP TABLE PRODUCT;
drop table emp;
drop table dept;
create table dept as select * from scott.dept;
alter table dept add constraint pkD primary key(deptno);
create table emp as select * from scott.emp;
alter table emp add constraint pkE primary key(empno);
alter table emp add constraint fkMgr foreign key(mgr) references emp(empno);
alter table emp add constraint kfDept foreign key(deptno) references dept(deptno);
CREATE TABLE PRODUCT (
        PRODUCT_ID              NUMBER (6),
        DESCRIPTION             VARCHAR2 (30));
 
CREATE TABLE PRICE (
        PRODUCT_ID              NUMBER (6),
        LIST_PRICE              NUMBER (8,2),
        MIN_PRICE               NUMBER (8,2),
        START_DATE              DATE,
        END_DATE                DATE);

CREATE TABLE CUSTOMER (
        CUSTOMER_ID             NUMBER (6),
        NAME                    VARCHAR2 (45),
        ADDRESS                 VARCHAR2 (40),
        CITY                    VARCHAR2 (30),
        STATE                   VARCHAR2 (2),
        ZIP_CODE                VARCHAR2 (9),
        AREA_CODE               NUMBER (3),
        PHONE_NUMBER            NUMBER (7),
        SALESPERSON_ID          NUMBER (4),
        CREDIT_LIMIT            NUMBER (9,2),
        COMMENTS                LONG);

CREATE TABLE SALES_ORDER  (
        ORDER_ID                NUMBER (4),
        ORDER_DATE              DATE,
        CUSTOMER_ID             NUMBER (6),
        SHIP_DATE               DATE,
        TOTAL                   NUMBER (8,2));

CREATE TABLE ITEM  (
        ORDER_ID                NUMBER (4),
        ITEM_ID                 NUMBER (4),
        PRODUCT_ID              NUMBER (6),
        ACTUAL_PRICE            NUMBER (8,2),
        QUANTITY                NUMBER (8),
        TOTAL                   NUMBER (8,2));

GRANT SELECT ON PRODUCT TO PUBLIC;
GRANT SELECT ON PRICE TO PUBLIC;
GRANT SELECT ON CUSTOMER TO PUBLIC;
GRANT SELECT ON SALES_ORDER TO PUBLIC;
GRANT SELECT ON ITEM TO PUBLIC;

INSERT INTO PRICE VALUES
   (100871,4.8,3.2,TO_DATE(2447528,'J'),TO_DATE(2447862,'J'));
INSERT INTO PRICE VALUES
   (100890,58,46.4,TO_DATE(2447528,'J'),NULL);
INSERT INTO PRICE VALUES
   (100890,54,40.5,TO_DATE(2447314,'J'),TO_DATE(2447527,'J'));
INSERT INTO PRICE VALUES
   (100860,35,28,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (100860,32,25.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (100860,30,24,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (100861,45,36,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (100861,42,33.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (100861,39,31.2,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (100870,2.8,2.4,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (100870,2.4,1.9,TO_DATE(2447528,'J'),TO_DATE(2447862,'J'));
INSERT INTO PRICE VALUES
   (100871,5.6,4.8,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (101860,24,18,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (101863,12.5,9.4,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (102130,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO PRICE VALUES
   (200376,2.4,1.75,TO_DATE(2448211,'J'),NULL);
INSERT INTO PRICE VALUES
   (200380,4,3.2,TO_DATE(2448211,'J'),NULL);
INSERT INTO PRICE VALUES
   (103120,23.2,18.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (103120,24,19.2,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (103120,25,20,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (103121,27.8,22.3,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (103121,28.8,23,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (103121,30,24,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (103130,4,3.5,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (103130,4.2,3.6,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (103131,4.2,3.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (103131,4.5,3.9,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (103140,20,15,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (103141,20,15,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (102132,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO PRICE VALUES
   (104350,40,32,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104350,42,33.6,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (104350,44,35.3,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (104351,23.6,18.9,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104351,24.8,19.8,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (104351,26,20.8,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (104352,50,35,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104352,54,37.8,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (104352,58.3,40.8,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (104360,36,29.5,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104360,39,32,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (104361,47,33,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (104361,50,35,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (104362,5,4,TO_DATE(2447573,'J'),NULL);
INSERT INTO PRICE VALUES
   (102134,3.4,2.8,TO_DATE(2447757,'J'),NULL);
INSERT INTO PRICE VALUES
   (105123,36.3,29,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (105123,37.7,32,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (105123,40,34,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (105124,10,7.6,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (105124,12,9,TO_DATE(2447893,'J'),TO_DATE(2448043,'J'));
INSERT INTO PRICE VALUES
   (105124,15,10,TO_DATE(2448044,'J'),NULL);
INSERT INTO PRICE VALUES
   (105125,2,1.7,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (105125,3,2.6,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (105126,5,4.3,TO_DATE(2447528,'J'),TO_DATE(2447892,'J'));
INSERT INTO PRICE VALUES
   (105126,6,5,TO_DATE(2447893,'J'),NULL);
INSERT INTO PRICE VALUES
   (105127,6,5,TO_DATE(2448211,'J'),NULL);
INSERT INTO PRICE VALUES
   (105128,10,8,TO_DATE(2448211,'J'),NULL);
INSERT INTO PRICE VALUES
   (102136,3.4,2.8,TO_DATE(2447757,'J'),NULL);

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 ('101863', 'SP JUNIOR RACKET');
INSERT INTO PRODUCT VALUES ('102130', 'RH: "GUIDE TO TENNIS"');
INSERT INTO PRODUCT VALUES ('200376', 'SB ENERGY BAR-6 PACK');
INSERT INTO PRODUCT VALUES ('200380', 'SB VITA SNACK-6 PACK');
INSERT INTO PRODUCT VALUES ( 103120 , 'WIFF SOFTBALL BAT I');
INSERT INTO PRODUCT VALUES ( 103121 , 'WIFF SOFTBALL BAT II');
INSERT INTO PRODUCT VALUES ( 103130 , 'WIFF SOFTBALL, SMALL');
INSERT INTO PRODUCT VALUES ( 103131 , 'WIFF SOFTBALL, LARGE');
INSERT INTO PRODUCT VALUES ( 103140 , 'WIFF SOFTBALL MITT (LH)');
INSERT INTO PRODUCT VALUES ( 103141 , 'WIFF SOFTBALL MITT (RH)');
INSERT INTO PRODUCT VALUES ( 102132 , 'RH: "GUIDE TO SOFTBALL"');
INSERT INTO PRODUCT VALUES ( 104350 , 'DUNK BASKETBALL INDOOR');
INSERT INTO PRODUCT VALUES ( 104351 , 'DUNK BASKETBALL OUTDOOR');
INSERT INTO PRODUCT VALUES ( 104352 , 'DUNK BASKETBALL PROFESSIONAL');
INSERT INTO PRODUCT VALUES ( 104360 , 'DUNK HOOP');
INSERT INTO PRODUCT VALUES ( 104361 , 'DUNK HOOP W/FIBERGLASS BOARD');
INSERT INTO PRODUCT VALUES ( 104362 , 'DUNK NETS - RAINBOW');
INSERT INTO PRODUCT VALUES ( 102134 , 'RH: "GUIDE TO BASKETBALL"');
INSERT INTO PRODUCT VALUES ( 105123 , 'YELLOW JERSEY BICYCLE HELMET');
INSERT INTO PRODUCT VALUES ( 105124 , 'YELLOW JERSEY BICYCLE GLOVES');
INSERT INTO PRODUCT VALUES ( 105125 , 'YELLOW JERSEY WATER BOTTLE');
INSERT INTO PRODUCT VALUES ( 105126 , 'YELLOW JERSEY BOTTLE CAGE');
INSERT INTO PRODUCT VALUES ( 105127 , 'YELLOW JERSEY FRAME PUMP');
INSERT INTO PRODUCT VALUES ( 105128 , 'YELLOW JERSEY SADDLE PACK');
INSERT INTO PRODUCT VALUES ( 102136 , 'RH: "GUIDE TO CYCLING"');

INSERT INTO SALES_ORDER VALUES
   (610,TO_DATE(2448264,'J'),101,TO_DATE(2448265,'J'),101.4);
INSERT INTO SALES_ORDER VALUES
   (611,TO_DATE(2448268,'J'),102,TO_DATE(2448268,'J'),45);
INSERT INTO SALES_ORDER VALUES
   (612,TO_DATE(2448272,'J'),104,TO_DATE(2448277,'J'),5860);
INSERT INTO SALES_ORDER VALUES
   (601,TO_DATE(2448013,'J'),106,TO_DATE(2448042,'J'),60.8);
INSERT INTO SALES_ORDER VALUES
   (602,TO_DATE(2448048,'J'),102,TO_DATE(2448063,'J'),56);
INSERT INTO SALES_ORDER VALUES
   (600,TO_DATE(2448013,'J'),103,TO_DATE(2448041,'J'),42);
INSERT INTO SALES_ORDER VALUES
   (604,TO_DATE(2448058,'J'),106,TO_DATE(2448073,'J'),642);
INSERT INTO SALES_ORDER VALUES
   (605,TO_DATE(2448087,'J'),106,TO_DATE(2448103,'J'),8374);
INSERT INTO SALES_ORDER VALUES
   (606,TO_DATE(2448087,'J'),100,TO_DATE(2448103,'J'),3.4);
INSERT INTO SALES_ORDER VALUES
   (609,TO_DATE(2448105,'J'),100,TO_DATE(2448119,'J'),102.5);
INSERT INTO SALES_ORDER VALUES
   (607,TO_DATE(2448091,'J'),104,TO_DATE(2448091,'J'),5.6);
INSERT INTO SALES_ORDER VALUES
   (608,TO_DATE(2448098,'J'),104,TO_DATE(2448098,'J'),35.2);
INSERT INTO SALES_ORDER VALUES
   (603,TO_DATE(2448048,'J'),102,TO_DATE(2448048,'J'),224);
INSERT INTO SALES_ORDER VALUES
   (620,TO_DATE(2448328,'J'),100,TO_DATE(2448328,'J'),4450);
INSERT INTO SALES_ORDER VALUES
   (613,TO_DATE(2448289,'J'),108,TO_DATE(2448289,'J'),6400);
INSERT INTO SALES_ORDER VALUES
   (614,TO_DATE(2448289,'J'),102,TO_DATE(2448293,'J'),23940);
INSERT INTO SALES_ORDER VALUES
   (616,TO_DATE(2448291,'J'),103,TO_DATE(2448298,'J'),764);
INSERT INTO SALES_ORDER VALUES
   (619,TO_DATE(2448310,'J'),104,TO_DATE(2448320,'J'),1260);
INSERT INTO SALES_ORDER VALUES
   (617,TO_DATE(2448293,'J'),105,TO_DATE(2448319,'J'),46370);
INSERT INTO SALES_ORDER VALUES
   (615,TO_DATE(2448289,'J'),107,TO_DATE(2448294,'J'),710);
INSERT INTO SALES_ORDER VALUES
   (618,TO_DATE(2448303,'J'),102,TO_DATE(2448322,'J'),3083);
INSERT INTO SALES_ORDER VALUES
   (621,TO_DATE(2448331,'J'),100,TO_DATE(2448348,'J'),730);
INSERT INTO SALES_ORDER VALUES
   (509,TO_DATE(2447682,'J'),226,TO_DATE(2447688,'J'),1174);
INSERT INTO SALES_ORDER VALUES
   (523,TO_DATE(2447936,'J'),226,TO_DATE(2447936,'J'),1165);
INSERT INTO SALES_ORDER VALUES
   (549,TO_DATE(2448253,'J'),226,TO_DATE(2448271,'J'),1620);
INSERT INTO SALES_ORDER VALUES
   (507,TO_DATE(2447673,'J'),228,TO_DATE(2447674,'J'),886);
INSERT INTO SALES_ORDER VALUES
   (516,TO_DATE(2447800,'J'),228,TO_DATE(2447803,'J'),1815);
INSERT INTO SALES_ORDER VALUES
   (553,TO_DATE(2448290,'J'),228,TO_DATE(2448301,'J'),4400);
INSERT INTO SALES_ORDER VALUES
   (526,TO_DATE(2447955,'J'),221,TO_DATE(2447958,'J'),7700);
INSERT INTO SALES_ORDER VALUES
   (543,TO_DATE(2448139,'J'),221,TO_DATE(2448142,'J'),8400);
INSERT INTO SALES_ORDER VALUES
   (555,TO_DATE(2448320,'J'),221,TO_DATE(2448323,'J'),8540);
INSERT INTO SALES_ORDER VALUES
   (559,TO_DATE(2448212,'J'),222,TO_DATE(2448370,'J'),387.2);
INSERT INTO SALES_ORDER VALUES
   (528,TO_DATE(2447975,'J'),224,TO_DATE(2447975,'J'),3770);
INSERT INTO SALES_ORDER VALUES
   (531,TO_DATE(2447982,'J'),224,TO_DATE(2447984,'J'),1400);
INSERT INTO SALES_ORDER VALUES
   (558,TO_DATE(2448347,'J'),224,TO_DATE(2448349,'J'),1700);
INSERT INTO SALES_ORDER VALUES
   (525,TO_DATE(2447951,'J'),225,TO_DATE(2447954,'J'),377);
INSERT INTO SALES_ORDER VALUES
   (552,TO_DATE(2448290,'J'),223,TO_DATE(2448295,'J'),555.8);
INSERT INTO SALES_ORDER VALUES
   (556,TO_DATE(2448326,'J'),223,TO_DATE(2448328,'J'),85);
INSERT INTO SALES_ORDER VALUES
   (560,TO_DATE(2448372,'J'),223,TO_DATE(2448372,'J'),72);
INSERT INTO SALES_ORDER VALUES
   (565,TO_DATE(2448409,'J'),227,TO_DATE(2448411,'J'),4900);
INSERT INTO SALES_ORDER VALUES
   (574,TO_DATE(2448540,'J'),201,TO_DATE(2448542,'J'),1685);
INSERT INTO SALES_ORDER VALUES
   (576,TO_DATE(2448543,'J'),201,TO_DATE(2448548,'J'),2058.9);
INSERT INTO SALES_ORDER VALUES
   (503,TO_DATE(2447611,'J'),201,TO_DATE(2447623,'J'),1876);
INSERT INTO SALES_ORDER VALUES
   (518,TO_DATE(2447820,'J'),201,TO_DATE(2447836,'J'),2932.5);
INSERT INTO SALES_ORDER VALUES
   (517,TO_DATE(2447823,'J'),201,TO_DATE(2447838,'J'),784);
INSERT INTO SALES_ORDER VALUES
   (544,TO_DATE(2448146,'J'),202,TO_DATE(2448150,'J'),2358);
INSERT INTO SALES_ORDER VALUES
   (524,TO_DATE(2447945,'J'),202,TO_DATE(2447955,'J'),1979);
INSERT INTO SALES_ORDER VALUES
   (502,TO_DATE(2447568,'J'),202,TO_DATE(2447581,'J'),500);
INSERT INTO SALES_ORDER VALUES
   (539,TO_DATE(2448069,'J'),202,TO_DATE(2448076,'J'),1300);
INSERT INTO SALES_ORDER VALUES
   (511,TO_DATE(2447756,'J'),202,TO_DATE(2447760,'J'),647);
INSERT INTO SALES_ORDER VALUES
   (512,TO_DATE(2447767,'J'),203,TO_DATE(2447783,'J'),428);
INSERT INTO SALES_ORDER VALUES
   (562,TO_DATE(2448381,'J'),203,TO_DATE(2448396,'J'),2044.5);
INSERT INTO SALES_ORDER VALUES
   (529,TO_DATE(2447984,'J'),203,TO_DATE(2447987,'J'),1264.7);
INSERT INTO SALES_ORDER VALUES
   (563,TO_DATE(2448402,'J'),204,TO_DATE(2448403,'J'),889);
INSERT INTO SALES_ORDER VALUES
   (568,TO_DATE(2448451,'J'),204,TO_DATE(2448459,'J'),1217.4);
INSERT INTO SALES_ORDER VALUES
   (504,TO_DATE(2447628,'J'),204,TO_DATE(2447629,'J'),1434.7);
INSERT INTO SALES_ORDER VALUES
   (538,TO_DATE(2448066,'J'),204,TO_DATE(2448069,'J'),741);
INSERT INTO SALES_ORDER VALUES
   (535,TO_DATE(2448040,'J'),204,TO_DATE(2448052,'J'),810);
INSERT INTO SALES_ORDER VALUES
   (578,TO_DATE(2448580,'J'),204,TO_DATE(2448595,'J'),2275.6);
INSERT INTO SALES_ORDER VALUES
   (534,TO_DATE(2448023,'J'),206,TO_DATE(2448027,'J'),420);
INSERT INTO SALES_ORDER VALUES
   (536,TO_DATE(2448033,'J'),206,TO_DATE(2448049,'J'),2135.6);
INSERT INTO SALES_ORDER VALUES
   (572,TO_DATE(2448488,'J'),206,TO_DATE(2448493,'J'),1200.5);
INSERT INTO SALES_ORDER VALUES
   (514,TO_DATE(2447775,'J'),207,TO_DATE(2447786,'J'),1140);
INSERT INTO SALES_ORDER VALUES
   (521,TO_DATE(2447851,'J'),207,TO_DATE(2447854,'J'),896.9);
INSERT INTO SALES_ORDER VALUES
   (551,TO_DATE(2448279,'J'),208,TO_DATE(2448294,'J'),1142);
INSERT INTO SALES_ORDER VALUES
   (513,TO_DATE(2447776,'J'),208,TO_DATE(2447784,'J'),1497);
INSERT INTO SALES_ORDER VALUES
   (508,TO_DATE(2447673,'J'),208,TO_DATE(2447686,'J'),1080);
INSERT INTO SALES_ORDER VALUES
   (515,TO_DATE(2447789,'J'),208,TO_DATE(2447796,'J'),1428.5);
INSERT INTO SALES_ORDER VALUES
   (542,TO_DATE(2448115,'J'),208,TO_DATE(2448127,'J'),2409);
INSERT INTO SALES_ORDER VALUES
   (573,TO_DATE(2448540,'J'),201,TO_DATE(2448542,'J'),1627);
INSERT INTO SALES_ORDER VALUES
   (566,TO_DATE(2448417,'J'),201,TO_DATE(2448420,'J'),3389.2);
INSERT INTO SALES_ORDER VALUES
   (520,TO_DATE(2447847,'J'),201,TO_DATE(2447850,'J'),341.6);
INSERT INTO SALES_ORDER VALUES
   (519,TO_DATE(2447820,'J'),201,TO_DATE(2447836,'J'),955);
INSERT INTO SALES_ORDER VALUES
   (575,TO_DATE(2448534,'J'),201,TO_DATE(2448547,'J'),684);
INSERT INTO SALES_ORDER VALUES
   (547,TO_DATE(2448181,'J'),202,TO_DATE(2448192,'J'),984.4);
INSERT INTO SALES_ORDER VALUES
   (540,TO_DATE(2448088,'J'),202,TO_DATE(2448090,'J'),861.2);
INSERT INTO SALES_ORDER VALUES
   (567,TO_DATE(2448443,'J'),202,TO_DATE(2448445,'J'),200);
INSERT INTO SALES_ORDER VALUES
   (570,TO_DATE(2448455,'J'),202,TO_DATE(2448462,'J'),663.6);
INSERT INTO SALES_ORDER VALUES
   (571,TO_DATE(2448471,'J'),202,TO_DATE(2448481,'J'),1095.6);
INSERT INTO SALES_ORDER VALUES
   (541,TO_DATE(2448112,'J'),203,TO_DATE(2448122,'J'),400);
INSERT INTO SALES_ORDER VALUES
   (532,TO_DATE(2447990,'J'),203,TO_DATE(2448003,'J'),1295.4);
INSERT INTO SALES_ORDER VALUES
   (527,TO_DATE(2447950,'J'),204,TO_DATE(2447965,'J'),3054.4);
INSERT INTO SALES_ORDER VALUES
   (501,TO_DATE(2447533,'J'),204,TO_DATE(2447538,'J'),216);
INSERT INTO SALES_ORDER VALUES
   (564,TO_DATE(2448402,'J'),204,TO_DATE(2448403,'J'),898.8);
INSERT INTO SALES_ORDER VALUES
   (537,TO_DATE(2448057,'J'),204,TO_DATE(2448069,'J'),672.9);
INSERT INTO SALES_ORDER VALUES
   (522,TO_DATE(2447899,'J'),204,TO_DATE(2447902,'J'),2578.8);
INSERT INTO SALES_ORDER VALUES
   (554,TO_DATE(2448306,'J'),204,TO_DATE(2448310,'J'),282.8);
INSERT INTO SALES_ORDER VALUES
   (569,TO_DATE(2448454,'J'),205,TO_DATE(2448461,'J'),2073);
INSERT INTO SALES_ORDER VALUES
   (550,TO_DATE(2448284,'J'),205,TO_DATE(2448295,'J'),2356);
INSERT INTO SALES_ORDER VALUES
   (548,TO_DATE(2448222,'J'),205,TO_DATE(2448238,'J'),666.9);
INSERT INTO SALES_ORDER VALUES
   (505,TO_DATE(2447624,'J'),206,TO_DATE(2447639,'J'),650);
INSERT INTO SALES_ORDER VALUES
   (577,TO_DATE(2448536,'J'),206,TO_DATE(2448550,'J'),1265.75);
INSERT INTO SALES_ORDER VALUES
   (533,TO_DATE(2448010,'J'),206,TO_DATE(2448014,'J'),1122.1);
INSERT INTO SALES_ORDER VALUES
   (561,TO_DATE(2448367,'J'),207,TO_DATE(2448384,'J'),2558.3);
INSERT INTO SALES_ORDER VALUES
   (506,TO_DATE(2447644,'J'),208,TO_DATE(2447657,'J'),2600.4);
INSERT INTO SALES_ORDER VALUES
   (530,TO_DATE(2447985,'J'),208,TO_DATE(2447989,'J'),3026.5);
INSERT INTO SALES_ORDER VALUES
   (545,TO_DATE(2448171,'J'),208,TO_DATE(2448178,'J'),475);
INSERT INTO SALES_ORDER VALUES
   (557,TO_DATE(2448324,'J'),208,TO_DATE(2448328,'J'),2461.8);
INSERT INTO SALES_ORDER VALUES
   (546,TO_DATE(2448182,'J'),208,TO_DATE(2448188,'J'),3663);
INSERT INTO SALES_ORDER VALUES
   (510,TO_DATE(2447726,'J'),208,TO_DATE(2447729,'J'),1336.6);

INSERT INTO ITEM VALUES (600,1,100861,42,1,42);
INSERT INTO ITEM VALUES (610,3,100890,58,1,58);
INSERT INTO ITEM VALUES (611,1,100861,45,1,45);
INSERT INTO ITEM VALUES (612,1,100860,30,100,3000);
INSERT INTO ITEM VALUES (601,1,200376,2.4,12,28.8);
INSERT INTO ITEM VALUES (601,2,100860,32,1,32);
INSERT INTO ITEM VALUES (602,1,100870,2.8,20,56);
INSERT INTO ITEM VALUES (604,1,100890,58,3,174);
INSERT INTO ITEM VALUES (604,2,100861,42,2,84);
INSERT INTO ITEM VALUES (604,3,100860,32,12,384);
INSERT INTO ITEM VALUES (603,1,100860,32,7,224);
INSERT INTO ITEM VALUES (610,1,100860,35,1,35);
INSERT INTO ITEM VALUES (610,2,100870,2.8,3,8.4);
INSERT INTO ITEM VALUES (613,4,200376,2.2,200,440);
INSERT INTO ITEM VALUES (614,1,100860,35,444,15540);
INSERT INTO ITEM VALUES (614,2,100870,2.8,1000,2800);
INSERT INTO ITEM VALUES (612,2,100861,40.5,20,810);
INSERT INTO ITEM VALUES (612,3,101863,10,150,1500);
INSERT INTO ITEM VALUES (620,1,100860,35,10,350);
INSERT INTO ITEM VALUES (620,2,200376,2.4,1000,2400);
INSERT INTO ITEM VALUES (620,3,102130,3.4,500,1700);
INSERT INTO ITEM VALUES (613,1,100871,5.6,100,560);
INSERT INTO ITEM VALUES (613,2,101860,24,200,4800);
INSERT INTO ITEM VALUES (613,3,200380,4,150,600);
INSERT INTO ITEM VALUES (619,3,102130,3.4,100,340);
INSERT INTO ITEM VALUES (617,1,100860,35,50,1750);
INSERT INTO ITEM VALUES (617,2,100861,45,100,4500);
INSERT INTO ITEM VALUES (614,3,100871,5.6,1000,5600);
INSERT INTO ITEM VALUES (616,1,100861,45,10,450);
INSERT INTO ITEM VALUES (616,2,100870,2.8,50,140);
INSERT INTO ITEM VALUES (616,3,100890,58,2,116);
INSERT INTO ITEM VALUES (616,4,102130,3.4,10,34);
INSERT INTO ITEM VALUES (616,5,200376,2.4,10,24);
INSERT INTO ITEM VALUES (619,1,200380,4,100,400);
INSERT INTO ITEM VALUES (619,2,200376,2.4,100,240);
INSERT INTO ITEM VALUES (615,1,100861,45,4,180);
INSERT INTO ITEM VALUES (607,1,100871,5.6,1,5.6);
INSERT INTO ITEM VALUES (615,2,100870,2.8,100,280);
INSERT INTO ITEM VALUES (617,3,100870,2.8,500,1400);
INSERT INTO ITEM VALUES (617,4,100871,5.6,500,2800);
INSERT INTO ITEM VALUES (617,5,100890,58,500,29000);
INSERT INTO ITEM VALUES (617,6,101860,24,100,2400);
INSERT INTO ITEM VALUES (617,7,101863,12.5,200,2500);
INSERT INTO ITEM VALUES (617,8,102130,3.4,100,340);
INSERT INTO ITEM VALUES (617,9,200376,2.4,200,480);
INSERT INTO ITEM VALUES (617,10,200380,4,300,1200);
INSERT INTO ITEM VALUES (609,2,100870,2.5,5,12.5);
INSERT INTO ITEM VALUES (609,3,100890,50,1,50);
INSERT INTO ITEM VALUES (618,1,100860,35,23,805);
INSERT INTO ITEM VALUES (618,2,100861,45,50,2250);
INSERT INTO ITEM VALUES (618,3,100870,2.8,10,28);
INSERT INTO ITEM VALUES (621,1,100861,45,10,450);
INSERT INTO ITEM VALUES (621,2,100870,2.8,100,280);
INSERT INTO ITEM VALUES (615,3,100871,5,50,250);
INSERT INTO ITEM VALUES (608,1,101860,24,1,24);
INSERT INTO ITEM VALUES (608,2,100871,5.6,2,11.2);
INSERT INTO ITEM VALUES (609,1,100861,40,1,40);
INSERT INTO ITEM VALUES (606,1,102130,3.4,1,3.4);
INSERT INTO ITEM VALUES (605,1,100861,45,100,4500);
INSERT INTO ITEM VALUES (605,2,100870,2.8,500,1400);
INSERT INTO ITEM VALUES (605,3,100890,58,5,290);
INSERT INTO ITEM VALUES (605,4,101860,24,50,1200);
INSERT INTO ITEM VALUES (605,5,101863,9.5,100,950);
INSERT INTO ITEM VALUES (605,6,102130,3.4,10,34);
INSERT INTO ITEM VALUES (612,4,100871,5.5,100,550);
INSERT INTO ITEM VALUES (619,4,100871,5.6,50,280);
INSERT INTO ITEM VALUES (509,1,105123,35,30,1050);
INSERT INTO ITEM VALUES (509,2,105124,9,10,90);
INSERT INTO ITEM VALUES (509,3,102136,3.4,10,34);
INSERT INTO ITEM VALUES (523,1,102136,3.4,10,34);
INSERT INTO ITEM VALUES (523,2,105123,37.7,30,1131);
INSERT INTO ITEM VALUES (549,1,105123,38,5,190);
INSERT INTO ITEM VALUES (549,2,105127,6,30,180);
INSERT INTO ITEM VALUES (549,3,105125,3,200,600);
INSERT INTO ITEM VALUES (549,4,105124,13,50,650);
INSERT INTO ITEM VALUES (507,1,105123,35.3,20,706);
INSERT INTO ITEM VALUES (507,2,105124,9,20,180);
INSERT INTO ITEM VALUES (516,1,105124,9,60,540);
INSERT INTO ITEM VALUES (516,2,102136,3.2,250,800);
INSERT INTO ITEM VALUES (516,3,105125,1.9,250,475);
INSERT INTO ITEM VALUES (553,1,105127,6,500,3000);
INSERT INTO ITEM VALUES (553,2,200376,1.75,800,1400);
INSERT INTO ITEM VALUES (526,1,105123,32,100,3200);
INSERT INTO ITEM VALUES (526,2,105124,9,500,4500);
INSERT INTO ITEM VALUES (543,1,105123,34,100,3400);
INSERT INTO ITEM VALUES (543,2,105124,10,500,5000);
INSERT INTO ITEM VALUES (555,1,105123,34,100,3400);
INSERT INTO ITEM VALUES (555,2,105124,10,500,5000);
INSERT INTO ITEM VALUES (555,3,102136,2.8,50,140);
INSERT INTO ITEM VALUES (559,1,105123,40,5,200);
INSERT INTO ITEM VALUES (559,2,105124,15,5,75);
INSERT INTO ITEM VALUES (559,3,105127,6,5,30);
INSERT INTO ITEM VALUES (559,4,102136,3.4,3,10.2);
INSERT INTO ITEM VALUES (559,5,200376,2.4,30,72);
INSERT INTO ITEM VALUES (528,1,105123,37.7,100,3770);
INSERT INTO ITEM VALUES (531,1,105124,11,100,1100);
INSERT INTO ITEM VALUES (531,2,102136,3,100,300);
INSERT INTO ITEM VALUES (558,1,105124,14,100,1400);
INSERT INTO ITEM VALUES (558,2,102136,3,100,300);
INSERT INTO ITEM VALUES (525,1,105123,37.7,10,377);
INSERT INTO ITEM VALUES (552,1,105123,40,10,400);
INSERT INTO ITEM VALUES (552,2,105124,15,10,150);
INSERT INTO ITEM VALUES (552,3,102136,3.4,1,3.4);
INSERT INTO ITEM VALUES (552,4,200376,2.4,1,2.4);
INSERT INTO ITEM VALUES (556,1,102136,3.4,25,85);
INSERT INTO ITEM VALUES (560,1,200376,2.4,30,72);
INSERT INTO ITEM VALUES (565,1,105123,37,100,3700);
INSERT INTO ITEM VALUES (565,2,105124,12,100,1200);
INSERT INTO ITEM VALUES (574,1,104350,41.8,25,1045);
INSERT INTO ITEM VALUES (574,2,200380,3.2,200,640);
INSERT INTO ITEM VALUES (576,1,104350,44,10,440);
INSERT INTO ITEM VALUES (576,2,104351,26,10,260);
INSERT INTO ITEM VALUES (576,3,104362,4.25,170,722.5);
INSERT INTO ITEM VALUES (576,4,200376,2.16,90,194.4);
INSERT INTO ITEM VALUES (576,5,200380,3.4,130,442);
INSERT INTO ITEM VALUES (503,1,104350,38,30,1140);
INSERT INTO ITEM VALUES (503,2,104351,23.6,10,236);
INSERT INTO ITEM VALUES (503,3,104352,50,10,500);
INSERT INTO ITEM VALUES (518,1,104350,38,25,950);
INSERT INTO ITEM VALUES (518,2,104351,23.6,20,472);
INSERT INTO ITEM VALUES (518,3,104360,36,20,720);
INSERT INTO ITEM VALUES (518,4,104362,4.25,170,722.5);
INSERT INTO ITEM VALUES (518,5,102134,3.4,20,68);
INSERT INTO ITEM VALUES (517,1,104352,50,15,750);
INSERT INTO ITEM VALUES (517,2,102134,3.4,10,34);
INSERT INTO ITEM VALUES (544,1,104350,44,15,660);
INSERT INTO ITEM VALUES (544,2,104351,26,15,390);
INSERT INTO ITEM VALUES (544,3,104352,58.3,10,583);
INSERT INTO ITEM VALUES (544,4,104361,50,10,500);
INSERT INTO ITEM VALUES (544,5,104362,4.5,50,225);
INSERT INTO ITEM VALUES (524,1,104350,42,10,420);
INSERT INTO ITEM VALUES (524,2,104351,23.56,35,824.6);
INSERT INTO ITEM VALUES (524,3,104362,4.25,150,637.5);
INSERT INTO ITEM VALUES (524,4,102134,3.23,30,96.9);
INSERT INTO ITEM VALUES (502,1,104352,50,10,500);
INSERT INTO ITEM VALUES (539,1,104351,26,20,520);
INSERT INTO ITEM VALUES (539,2,104360,39,20,780);
INSERT INTO ITEM VALUES (511,1,104351,23.6,15,354);
INSERT INTO ITEM VALUES (511,2,104362,4.5,50,225);
INSERT INTO ITEM VALUES (511,3,102134,3.4,20,68);
INSERT INTO ITEM VALUES (512,1,104360,36,10,360);
INSERT INTO ITEM VALUES (512,2,102134,3.4,20,68);
INSERT INTO ITEM VALUES (562,1,104351,24.7,25,617.5);
INSERT INTO ITEM VALUES (562,2,104352,58.3,15,874.5);
INSERT INTO ITEM VALUES (562,3,104362,4.25,130,552.5);
INSERT INTO ITEM VALUES (529,1,104350,39.89,30,1196.7);
INSERT INTO ITEM VALUES (529,2,102134,3.4,20,68);
INSERT INTO ITEM VALUES (563,1,104352,58.3,10,583);
INSERT INTO ITEM VALUES (563,2,200376,2.04,150,306);
INSERT INTO ITEM VALUES (568,1,104351,24.7,30,741);
INSERT INTO ITEM VALUES (568,2,200376,2.04,110,224.4);
INSERT INTO ITEM VALUES (568,3,200380,3.6,70,252);
INSERT INTO ITEM VALUES (504,1,104350,40,10,400);
INSERT INTO ITEM VALUES (504,2,104351,22.42,35,784.7);
INSERT INTO ITEM VALUES (504,3,104352,50,5,250);
INSERT INTO ITEM VALUES (538,1,104351,24.7,30,741);
INSERT INTO ITEM VALUES (535,1,104352,54,15,810);
INSERT INTO ITEM VALUES (578,1,104350,41.8,40,1672);
INSERT INTO ITEM VALUES (578,2,200376,2.04,190,387.6);
INSERT INTO ITEM VALUES (578,3,200380,3.6,60,216);
INSERT INTO ITEM VALUES (534,1,104350,42,10,420);
INSERT INTO ITEM VALUES (536,1,104350,39.89,40,1595.6);
INSERT INTO ITEM VALUES (536,2,104352,54,10,540);
INSERT INTO ITEM VALUES (572,1,104351,24.7,25,617.5);
INSERT INTO ITEM VALUES (572,2,104352,58.3,10,583);
INSERT INTO ITEM VALUES (514,1,104350,38,30,1140);
INSERT INTO ITEM VALUES (521,1,104350,40,20,800);
INSERT INTO ITEM VALUES (521,2,102134,3.23,30,96.9);
INSERT INTO ITEM VALUES (551,1,104350,44,10,440);
INSERT INTO ITEM VALUES (551,2,104361,50,5,250);
INSERT INTO ITEM VALUES (551,3,102134,3.4,20,68);
INSERT INTO ITEM VALUES (551,4,200376,1.92,200,384);
INSERT INTO ITEM VALUES (513,1,104350,40,15,600);
INSERT INTO ITEM VALUES (513,2,104351,23.6,20,472);
INSERT INTO ITEM VALUES (513,3,104362,4.25,100,425);
INSERT INTO ITEM VALUES (508,1,104360,36,20,720);
INSERT INTO ITEM VALUES (508,2,104362,4.5,80,360);
INSERT INTO ITEM VALUES (515,1,104350,40,20,800);
INSERT INTO ITEM VALUES (515,2,104351,22.42,25,560.5);
INSERT INTO ITEM VALUES (515,3,102134,3.4,20,68);
INSERT INTO ITEM VALUES (542,1,104350,41.8,25,1045);
INSERT INTO ITEM VALUES (542,2,104360,39,20,780);
INSERT INTO ITEM VALUES (542,3,104361,50,11,550);
INSERT INTO ITEM VALUES (542,4,102134,3.4,10,34);
INSERT INTO ITEM VALUES (573,1,103120,22.5,50,1125);
INSERT INTO ITEM VALUES (573,2,103131,4.04,50,202);
INSERT INTO ITEM VALUES (573,3,103141,20,15,300);
INSERT INTO ITEM VALUES (566,1,103120,23.75,40,950);
INSERT INTO ITEM VALUES (566,2,103121,27,50,1350);
INSERT INTO ITEM VALUES (566,3,103130,3.77,60,226.2);
INSERT INTO ITEM VALUES (566,4,103131,3.9,170,663);
INSERT INTO ITEM VALUES (566,5,103141,20,10,200);
INSERT INTO ITEM VALUES (520,1,103130,4,10,40);
INSERT INTO ITEM VALUES (520,2,103131,3.77,80,301.6);
INSERT INTO ITEM VALUES (519,1,103130,3.5,110,385);
INSERT INTO ITEM VALUES (519,2,103140,19,30,570);
INSERT INTO ITEM VALUES (575,1,103140,19,30,570);
INSERT INTO ITEM VALUES (575,2,200380,3.8,30,114);
INSERT INTO ITEM VALUES (547,1,103130,3.77,80,301.6);
INSERT INTO ITEM VALUES (547,2,103131,4.04,70,282.8);
INSERT INTO ITEM VALUES (547,3,103140,20,15,300);
INSERT INTO ITEM VALUES (547,4,103141,20,5,100);
INSERT INTO ITEM VALUES (540,1,103130,3.98,40,159.2);
INSERT INTO ITEM VALUES (540,2,103131,3.9,180,702);
INSERT INTO ITEM VALUES (567,1,103140,20,10,200);
INSERT INTO ITEM VALUES (570,1,103131,4.04,90,363.6);
INSERT INTO ITEM VALUES (570,2,103140,20,15,300);
INSERT INTO ITEM VALUES (571,1,103131,4.04,70,282.8);
INSERT INTO ITEM VALUES (571,2,103140,19,25,475);
INSERT INTO ITEM VALUES (571,3,102132,3.4,15,51);
INSERT INTO ITEM VALUES (571,4,200376,2.16,80,172.8);
INSERT INTO ITEM VALUES (571,5,200380,3.8,30,114);
INSERT INTO ITEM VALUES (541,1,103140,20,10,200);
INSERT INTO ITEM VALUES (541,2,103141,20,10,200);
INSERT INTO ITEM VALUES (532,1,103120,21.59,60,1295.4);
INSERT INTO ITEM VALUES (527,1,103120,21.59,60,1295.4);
INSERT INTO ITEM VALUES (527,2,103121,27.35,40,1094);
INSERT INTO ITEM VALUES (527,3,103140,19,35,665);
INSERT INTO ITEM VALUES (501,1,103130,3.6,60,216);
INSERT INTO ITEM VALUES (564,1,103130,3.77,80,301.6);
INSERT INTO ITEM VALUES (564,2,103131,3.9,120,468);
INSERT INTO ITEM VALUES (564,3,102132,3.23,40,129.2);
INSERT INTO ITEM VALUES (537,1,103130,3.6,160,576);
INSERT INTO ITEM VALUES (537,2,102132,3.23,30,96.9);
INSERT INTO ITEM VALUES (522,1,103120,21.59,80,1727.2);
INSERT INTO ITEM VALUES (522,2,103121,28.8,10,288);
INSERT INTO ITEM VALUES (522,3,103131,4.04,90,363.6);
INSERT INTO ITEM VALUES (522,4,103141,20,10,200);
INSERT INTO ITEM VALUES (554,1,103131,4.04,70,282.8);
INSERT INTO ITEM VALUES (569,1,103120,22.5,50,1125);
INSERT INTO ITEM VALUES (569,2,103130,3.6,180,648);
INSERT INTO ITEM VALUES (569,3,103141,20,15,300);
INSERT INTO ITEM VALUES (550,1,103120,22.5,60,1350);
INSERT INTO ITEM VALUES (550,2,103140,19,45,855);
INSERT INTO ITEM VALUES (550,3,103141,20,5,100);
INSERT INTO ITEM VALUES (550,4,102132,3.4,15,51);
INSERT INTO ITEM VALUES (548,1,103140,19,30,570);
INSERT INTO ITEM VALUES (548,2,102132,3.23,30,96.9);
INSERT INTO ITEM VALUES (505,1,103130,3.5,100,350);
INSERT INTO ITEM VALUES (505,2,103140,20,15,300);
INSERT INTO ITEM VALUES (577,1,103121,30,20,600);
INSERT INTO ITEM VALUES (577,2,103131,3.9,150,585);
INSERT INTO ITEM VALUES (577,3,102132,3.23,25,80.75);
INSERT INTO ITEM VALUES (533,1,103121,27.35,30,820.5);
INSERT INTO ITEM VALUES (533,2,103130,3.77,80,301.6);
INSERT INTO ITEM VALUES (561,1,103120,22.5,80,1800);
INSERT INTO ITEM VALUES (561,2,103130,3.77,70,263.9);
INSERT INTO ITEM VALUES (561,3,103141,20,15,300);
INSERT INTO ITEM VALUES (561,4,200376,2.16,90,194.4);
INSERT INTO ITEM VALUES (506,1,103120,20.88,80,1670.4);
INSERT INTO ITEM VALUES (506,2,103130,3.5,180,630);
INSERT INTO ITEM VALUES (506,3,103141,20,15,300);
INSERT INTO ITEM VALUES (530,1,103121,25.91,50,1295.5);
INSERT INTO ITEM VALUES (530,2,103130,3.6,200,720);
INSERT INTO ITEM VALUES (530,3,103140,19,40,760);
INSERT INTO ITEM VALUES (530,4,103141,20,10,200);
INSERT INTO ITEM VALUES (530,5,102132,3.4,15,51);
INSERT INTO ITEM VALUES (545,1,103140,19,25,475);
INSERT INTO ITEM VALUES (557,1,103120,23.75,40,950);
INSERT INTO ITEM VALUES (557,2,103121,30,10,300);
INSERT INTO ITEM VALUES (557,3,103140,19,35,665);
INSERT INTO ITEM VALUES (557,4,200376,2.16,80,172.8);
INSERT INTO ITEM VALUES (557,5,200380,3.4,110,374);
INSERT INTO ITEM VALUES (546,1,103120,22.5,50,1125);
INSERT INTO ITEM VALUES (546,2,103121,30,20,600);
INSERT INTO ITEM VALUES (546,3,103130,3.6,120,432);
INSERT INTO ITEM VALUES (546,4,103131,3.9,140,546);
INSERT INTO ITEM VALUES (546,5,103140,19,40,760);
INSERT INTO ITEM VALUES (546,6,103141,20,10,200);
INSERT INTO ITEM VALUES (510,1,103120,20.88,60,1252.8);
INSERT INTO ITEM VALUES (510,2,103131,4.19,20,83.8);

INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('96711', 'CA', '7844', '5986609', 
  'JOCKSPORTS',
  '100', '5000', 'BELMONT', '415', '345 VIEWRIDGE', 
  'Very friendly people to work with -- sales rep likes to be called Mike.');
 
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('94061', 'CA', '7521', '3681223',
  'TKB SPORT SHOP',
  '101', '10000', 'REDWOOD CITY', '415', '490 BOLI RD.', 
  'Rep called 5/8 about change in order - contact shipping.');
                                                              
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('95133', 'CA', '7654', '6443341', 
  'VOLLYRITE',
  '102', '7000', 'BURLINGAME', '415', '9722 HAMILTON', 
  'Company doing heavy promotion beginning 10/89. Prepare for large orders during winter.');
 
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('97544', 'CA', '7521', '6779312',
  'JUST TENNIS',
  '103', '3000', 'BURLINGAME', '415', 'HILLVIEW MALL', 
  'Contact rep about new line of tennis rackets.');
                                                             
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('93301', 'CA', '7499', '9962323',
  'EVERY MOUNTAIN',
  '104', '10000', 'CUPERTINO', '408', '574 SURRY RD.', 
  'Customer with high market share (23%) due to aggressive advertising.');
                                                      
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('91003', 'CA', '7844', '3769966',
  'K + T SPORTS',
  '105', '5000', 'SANTA CLARA', '408', '3476 EL PASEO', 
  'Tends to order large amounts of merchandise at once. Accounting is considering raising their credit limit. Usually pays on time.');
                                                      
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('94301', 'CA', '7521', '3649777',
  'SHAPE UP',
  '106', '6000', 'PALO ALTO', '415', '908 SEQUOIA', 
  'Support intensive. Orders small amounts (< 800) of merchandise at a time.');
 
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('93301', 'CA', '7499', '9674398',
  'WOMENS SPORTS',
  '107', '10000', 'SUNNYVALE', '408', 'VALCO VILLAGE', 
  'First sporting goods store geared exclusively towards women. Unusual promotional style and very willing to take chances towards new products!');
            
INSERT INTO CUSTOMER
  (ZIP_CODE, STATE, SALESPERSON_ID, PHONE_NUMBER, 
  NAME, 
  CUSTOMER_ID, CREDIT_LIMIT, CITY, AREA_CODE, ADDRESS, 
  COMMENTS)
  VALUES ('55649', 'MN', '7844', '5669123',
  'NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER',
  '108', '8000', 'HIBBING', '612', '98 LONE PINE WAY', '');

INSERT INTO CUSTOMER VALUES
  ( 201 , 'STADIUM SPORTS', '47 IRVING PL.',
  'NEW YORK', 'NY', '10003',
  '212', '5555335',  7557 ,  10000 ,
  'Large general-purpose sports store with an affluent customer base.');

INSERT INTO CUSTOMER VALUES
  ( 202 , 'HOOPS', '2345 ADAMS AVE.',
  'LEICESTER', 'MA', '01524',
  '508', '5557542',  7820 ,  5000 ,
  'Specializes in basketball equipment.');

INSERT INTO CUSTOMER VALUES
  ( 203 , 'REBOUND SPORTS', '2 E. 14TH ST.',
  'NEW YORK', 'NY', '10009',
  '212', '5555989',  7557 ,  10000 ,
  'Follow up on the promotion proposal.');

INSERT INTO CUSTOMER VALUES
  ( 204 , 'THE POWER FORWARD', '1 KNOTS LANDING',
  'DALLAS', 'TX', '75248',
  '214', '5550505',  7560 ,  12000 ,
  'Large floorspace.  Prefers maintaining large amounts of inventory on hand.');

INSERT INTO CUSTOMER VALUES
  ( 205 , 'POINT GUARD', '20 THURSTON ST.',
  'YONKERS', 'NY', '10956',
  '914', '5554766',  7557 ,  3000 ,
  'Tremendous potential for an exclusive agreement.');

INSERT INTO CUSTOMER VALUES
  ( 206 , 'THE COLISEUM', '5678 WILBUR PL.',
  'SCARSDALE', 'NY', '10583',
  '914', '5550217',  7557 ,  6000 ,
  'Contact rep. about new product lines.');

INSERT INTO CUSTOMER VALUES
  ( 207 , 'FAST BREAK', '1000 HERBERT LN.',
  'CONCORD', 'MA', '01742',
  '508', '5551298',  7820 ,  7000 ,
  'Customer requires written price quotes before making purchase requisitions.');

INSERT INTO CUSTOMER VALUES
  ( 208 , 'AL AND BOB''S SPORTS', '260 YORKTOWN CT.',
  'AUSTIN', 'TX', '78731',
  '512', '5557631',  7560 ,  4000 ,
  'Very personal purchasing agents -- Sharon and Scott.');

INSERT INTO CUSTOMER VALUES
  ( 211 , 'AT BAT', '234 BEACHEM ST.',
  'BROOKLINE', 'MA', '02146',
  '617', '5557385',  7820 ,  8000 ,
  'Have an open purchase order for $3000.  Ship immediately on request.');

INSERT INTO CUSTOMER VALUES
  ( 212 , 'ALL SPORT', '1000 38TH ST.',
  'BROOKLYN', 'NY', '11210',
  '718', '5551739',  7600 ,  6000 ,
  'Pursue a contract -- possible candidate for volume purchasing agreements.');

INSERT INTO CUSTOMER VALUES
  ( 213 , 'GOOD SPORT', '400 46TH ST.',
  'SUNNYSIDE', 'NY', '11104',
  '718', '5553771',  7600 ,  5000 ,
  'May be moving to a larger location.');

INSERT INTO CUSTOMER VALUES
  ( 214 , 'AL''S PRO SHOP', '45 SPRUCE ST.',
  'SPRING', 'TX', '77388',
  '713', '5555172',  7564 ,  8000 ,
  'Target market is serious athletes.');

INSERT INTO CUSTOMER VALUES
  ( 215 , 'BOB''S FAMILY SPORTS', '400 E. 23RD',
  'HOUSTON', 'TX', '77026',
  '713', '5558015',  7654 ,  8000 ,
  'Target market is casual and weekend athletes.  Offers a large selection.');

INSERT INTO CUSTOMER VALUES
  ( 216 , 'THE ALL AMERICAN', '547 PRENTICE RD.',
  'CHELSEA', 'MA', '02150',
  '617', '5553047',  7820 ,  5000 ,
  'Customer prefers to be called between 10 and 12.');

INSERT INTO CUSTOMER VALUES
  ( 217 , 'HIT, THROW, AND RUN', '333 WOOD COURT',
  'GRAPEVINE', 'TX', '76051',
  '817', '5552352',  7564 ,  6000 ,
  'General purpose sports store.');

INSERT INTO CUSTOMER VALUES
  ( 218 , 'THE OUTFIELD', '346 GARDEN BLVD.',
  'FLUSHING', 'NY', '11355',
  '718', '5552131',  7820 ,  4000 ,
  'Store does not open until 11am and does not have an answering service.');

INSERT INTO CUSTOMER VALUES
  ( 221 , 'WHEELS AND DEALS', '2 MEMORIAL DRIVE',
  'HOUSTON', 'TX', '77007',
  '713', '5554139',  7789 ,  10000 ,
  'Discount bicycle and sporting good store.');

INSERT INTO CUSTOMER VALUES
  ( 222 , 'JUST BIKES', '4000 PARKRIDGE BLVD.',
  'DALLAS', 'TX', '75205',
  '214', '5558735',  7789 ,  4000 ,
  'Exclusive bicycle dealer.');

INSERT INTO CUSTOMER VALUES
  ( 223 , 'VELO SPORTS', '23 WHITE ST.',
  'MALDEN', 'MA', '02148',
  '617', '5554983',  7820 ,  5000 ,
  'Clerk answers all phone lines.  Ask for Mike.');

INSERT INTO CUSTOMER VALUES
  ( 224 , 'JOE''S BIKE SHOP', '4500 FOX COURT',
  'GRAND PRARIE', 'TX', '75051',
  '214', '5559834',  7789 ,  6000 ,
  'Call Joe to make sure last shipment was complete.');

INSERT INTO CUSTOMER VALUES
  ( 225 , 'BOB''S SWIM, CYCLE, AND RUN', '300 HORSECREEK CIRCLE',
  'IRVING', 'TX', '75039',
  '214', '5558388',  7789 ,  7000 ,
  'Store catering to triathletes.');

INSERT INTO CUSTOMER VALUES
  ( 226 , 'CENTURY SHOP', '8 DAGMAR DR.',
  'HUNTINGTON', 'NY', '11743',
  '516', '5553006',  7555 ,  4000 ,
  'Customer in the midst of a cost-cutting program.');

INSERT INTO CUSTOMER VALUES
  ( 227 , 'THE TOUR', '2500 GARDNER RD.',
  'SOMERVILLE', 'MA', '02144',
  '617', '5556673',  7820 ,  5000 ,
  'Customer referred to us by The All American.');

INSERT INTO CUSTOMER VALUES
  ( 228 , 'FITNESS FIRST', '5000 85TH ST.',
  'JACKSON HEIGHTS', 'NY', '11372',
  '718', '5558710',  7555 ,  4000 ,
  'Recently acquired another sporting goods store.  Expect higher volume in the future.');

COMMIT;

CREATE UNIQUE INDEX I_PRODUCT$PRODUCT_ID ON PRODUCT (PRODUCT_ID);
CREATE UNIQUE INDEX I_PRICE ON PRICE (PRODUCT_ID, START_DATE);
CREATE UNIQUE INDEX I_CUSTOMER$CUSTOMER_ID ON CUSTOMER (CUSTOMER_ID);
CREATE UNIQUE INDEX I_SALES_ORDER$ORDER_ID ON SALES_ORDER (ORDER_ID);
CREATE UNIQUE INDEX I_ITEM ON ITEM (ORDER_ID, ITEM_ID);

REM Add constraints

ALTER TABLE CUSTOMER ADD /* CONSTRAINT CUSTOMER_ID_NN */
   CHECK (CUSTOMER_ID IS NOT NULL);
ALTER TABLE CUSTOMER ADD /* CONSTRAINT SALESPERSON_ID_NN */
   CHECK (SALESPERSON_ID IS NOT NULL);
ALTER TABLE CUSTOMER ADD /* CONSTRAINT CUSTOMER_ID_ZERO */
   CHECK (CUSTOMER_ID > 0);
ALTER TABLE CUSTOMER ADD /* CONSTRAINT STATE_ALL_CAPS */
   CHECK (STATE = UPPER(STATE));
ALTER TABLE CUSTOMER ADD /* CONSTRAINT ZIP_CODE_FULL */
   CHECK (LENGTH(NVL(ZIP_CODE, '99999')) IN (5, 9));
ALTER TABLE ITEM ADD /* CONSTRAINT ITEM$ORDER_ID_NN */
   CHECK (ORDER_ID IS NOT NULL);
ALTER TABLE ITEM ADD /* CONSTRAINT ITEM_ID_NN */
   CHECK (ITEM_ID IS NOT NULL);
ALTER TABLE PRICE ADD /* CONSTRAINT PRICE$PRODUCT_ID_NN */
   CHECK (PRODUCT_ID IS NOT NULL);
ALTER TABLE PRICE ADD /* CONSTRAINT START_DATE_NN */
   CHECK (START_DATE IS NOT NULL);
ALTER TABLE PRICE ADD /* CONSTRAINT MIN_PRICE_LESS */
   CHECK (LIST_PRICE IS NULL OR MIN_PRICE IS NULL OR MIN_PRICE <= LIST_PRICE);
ALTER TABLE PRICE ADD /* CONSTRAINT START_DATE_LESS */
   CHECK (END_DATE IS NULL OR START_DATE <= END_DATE);
ALTER TABLE PRODUCT ADD /* CONSTRAINT PRODUCT_ID_NN */
   CHECK (PRODUCT_ID IS NOT NULL);
ALTER TABLE SALES_ORDER ADD /* CONSTRAINT ORDER_ID_NN */
   CHECK (ORDER_ID IS NOT NULL);
ALTER TABLE SALES_ORDER ADD /* CONSTRAINT ORDER$CUSTOMER_ID_NN */
   CHECK (CUSTOMER_ID IS NOT NULL);
ALTER TABLE SALES_ORDER ADD /* CONSTRAINT SALES_TOTAL_ZERO */
   CHECK (TOTAL >= 0);

ALTER TABLE CUSTOMER ADD /* CONSTRAINT CUSTOMER_PRIMARY_KEY */
   PRIMARY KEY (CUSTOMER_ID);
ALTER TABLE ITEM ADD /* CONSTRAINT ITEM_PRIMARY_KEY */
   PRIMARY KEY (ORDER_ID, ITEM_ID);
ALTER TABLE PRICE ADD /* CONSTRAINT PRICE_PRIMARY_KEY */
   PRIMARY KEY (PRODUCT_ID, START_DATE);
ALTER TABLE PRODUCT ADD /* CONSTRAINT PRODUCT_PRIMARY_KEY */
   PRIMARY KEY (PRODUCT_ID);
ALTER TABLE SALES_ORDER ADD /* CONSTRAINT SALES_ORDER_PRIMARY_KEY */
   PRIMARY KEY (ORDER_ID);


rem ALTER TABLE CUSTOMER ADD /* CONSTRAINT CUSTOMER_FOREIGN_KEY  */
rem    FOREIGN KEY(SALESPERSON_ID) REFERENCES EMP(empno);
ALTER TABLE ITEM ADD /* CONSTRAINT ITEM_ORDER_FOREIGN_KEY  */
   FOREIGN KEY (ORDER_ID) REFERENCES SALES_ORDER;
ALTER TABLE ITEM ADD /* CONSTRAINT ITEM_PRODUCT_FOREIGN_KEY  */
   FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT;
ALTER TABLE PRICE ADD /* CONSTRAINT PRICE_FOREIGN_KEY  */
   FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT;
ALTER TABLE SALES_ORDER ADD /* CONSTRAINT SALES_ORDER_FOREIGN_KEY  */
   FOREIGN KEY (CUSTOMER_ID) REFERENCES CUSTOMER;
