Oracle Live SQL - Script: dwsalesfact

Statement 1

CREATE TABLE DWVENDOR ( 
V_CODE 		INTEGER PRIMARY KEY, 
V_NAME		VARCHAR(35), 
V_AREACODE 	CHAR(3), 
V_STATE 	CHAR(2))

Statement 2

CREATE TABLE DWPRODUCT ( 
P_CODE 		VARCHAR(10) PRIMARY KEY, 
P_DESCRIPT 	VARCHAR(35), 
P_CATEGORY	VARCHAR(5), 
V_CODE		NUMBER REFERENCES DWVENDOR)

Statement 3

CREATE TABLE DWREGION ( 
REG_ID		INTEGER PRIMARY KEY, 
REG_NAME	VARCHAR(10))

Statement 4

CREATE TABLE DWCUSTOMER ( 
CUS_CODE	NUMBER PRIMARY KEY, 
CUS_LNAME	VARCHAR(15), 
CUS_FNAME	VARCHAR(15), 
CUS_INITIAL	CHAR(1), 
CUS_STATE 	CHAR(2), 
REG_ID		NUMBER REFERENCES DWREGION)

Statement 5

CREATE TABLE DWTIME ( 
TM_ID		INTEGER PRIMARY KEY, 
TM_YEAR		INTEGER, 
TM_MONTH	INTEGER, 
TM_DAY		INTEGER, 
TM_QTR 		INTEGER)

Statement 6

CREATE TABLE DWSALESFACT ( 
TM_ID  		NUMBER, 
CUS_CODE	NUMBER, 
P_CODE		VARCHAR(10), 
SALE_UNITS	NUMBER, 
SALE_PRICE 	NUMBER, 
PRIMARY KEY (TM_ID, CUS_CODE, P_CODE))

Statement 7

SET ESCAPE ON

Statement 8

INSERT INTO DWVENDOR VALUES(21225,'Bryson, Inc.'    ,'615','TN')

Statement 9

INSERT INTO DWVENDOR VALUES(21226,'SuperLoo, Inc.'  ,'904','FL')

Statement 10

INSERT INTO DWVENDOR VALUES(21231,'D\&E Supply'     ,'615','TN')

Statement 11

INSERT INTO DWVENDOR VALUES(21344,'Gomez Bros.'     ,'615','KY')

Statement 12

INSERT INTO DWVENDOR VALUES(22567,'Dome Supply'     ,'901','GA')

Statement 13

INSERT INTO DWVENDOR VALUES(23119,'Randsets Ltd.'   ,'901','GA')

Statement 14

INSERT INTO DWVENDOR VALUES(24004,'Brackman Bros.'  ,'615','TN')

Statement 15

INSERT INTO DWVENDOR VALUES(24288,'ORDVA, Inc.'     ,'615','TN')

Statement 16

INSERT INTO DWVENDOR VALUES(25443,'B\&K, Inc.'      ,'904','FL')

Statement 17

INSERT INTO DWVENDOR VALUES(25501,'Damal Supplies'  ,'615','TN')

Statement 18

INSERT INTO DWVENDOR VALUES(25595,'Rubicon Systems' ,'904','FL')

Statement 19

INSERT INTO DWPRODUCT VALUES('11QER/31','Power painter, 15 psi., 3-nozzle'     ,'CAT1',25595)

Statement 20

INSERT INTO DWPRODUCT VALUES('13-Q2/P2','7.25-in. pwr. saw blade'              ,'CAT1',21344)

Statement 21

INSERT INTO DWPRODUCT VALUES('14-Q1/L3','9.00-in. pwr. saw blade'              ,'CAT1',21344)

Statement 22

INSERT INTO DWPRODUCT VALUES('1546-QQ2','Hrd. cloth, 1/4-in., 2x50'            ,'CAT2',23119)

Statement 23

INSERT INTO DWPRODUCT VALUES('1558-QW1','Hrd. cloth, 1/2-in., 3x50'            ,'CAT2',23119)

Statement 24

INSERT INTO DWPRODUCT VALUES('2232/QTY','B\&D jigsaw, 12-in. blade'            ,'CAT2',24288)

Statement 25

INSERT INTO DWPRODUCT VALUES('2232/QWE','B\&D jigsaw, 8-in. blade'             ,'CAT3',24288)

Statement 26

INSERT INTO DWPRODUCT VALUES('2238/QPD','B\&D cordless drill, 1/2-in.'         ,'CAT3',25595)

Statement 27

INSERT INTO DWPRODUCT VALUES('23109-HB','Claw hammer'                          ,'CAT4',21225)

Statement 28

INSERT INTO DWPRODUCT VALUES('23114-AA','Sledge hammer, 12 lb.'                ,'CAT4',21225)

Statement 29

INSERT INTO DWPRODUCT VALUES('54778-2T','Rat-tail file, 1/8-in. fine'          ,'CAT1',21344)

Statement 30

INSERT INTO DWPRODUCT VALUES('89-WRE-Q','Hicut chain saw, 16 in.'              ,'CAT2',24288)

Statement 31

INSERT INTO DWPRODUCT VALUES('PVC23DRT','PVC pipe, 3.5-in., 8-ft'              ,'CAT3',21225)

Statement 32

INSERT INTO DWPRODUCT VALUES('SM-18277','1.25-in. metal screw, 25'             ,'CAT4',21225)

Statement 33

INSERT INTO DWPRODUCT VALUES('SW-23116','2.5-in. wd. screw, 50'                ,'CAT2',21231)

Statement 34

INSERT INTO DWPRODUCT VALUES('WR3/TT3' ,'Steel matting, 4''x8''x1/6", .5" mesh','CAT3',25595)

Statement 35

INSERT INTO DWREGION VALUES(1,'NE')

Statement 36

INSERT INTO DWREGION VALUES(2,'NW')

Statement 37

INSERT INTO DWREGION VALUES(3,'SE')

Statement 38

INSERT INTO DWREGION VALUES(4,'SW')

Statement 39

INSERT INTO DWCUSTOMER VALUES(10010,'Ramas'   ,'Alfred','A' ,'TN',3)

Statement 40

INSERT INTO DWCUSTOMER VALUES(10011,'Dunne'   ,'Leona' ,'K' ,'GA',3)

Statement 41

INSERT INTO DWCUSTOMER VALUES(10012,'Smith'   ,'Kathy' ,'W' ,'NY',1)

Statement 42

INSERT INTO DWCUSTOMER VALUES(10013,'Olowski' ,'Paul'  ,'F' ,'NJ',1)

Statement 43

INSERT INTO DWCUSTOMER VALUES(10014,'Orlando' ,'Myron' ,NULL,'CO',2)

Statement 44

INSERT INTO DWCUSTOMER VALUES(10015,'O''Brian','Amy'   ,'B' ,'TN',3)

Statement 45

INSERT INTO DWCUSTOMER VALUES(10016,'Brown'   ,'James' ,'G' ,'GA',3)

Statement 46

INSERT INTO DWCUSTOMER VALUES(10017,'Williams','George',NULL,'CA',4)

Statement 47

INSERT INTO DWCUSTOMER VALUES(10018,'Farriss' ,'Anne'  ,'G' ,'CA',4)

Statement 48

INSERT INTO DWCUSTOMER VALUES(10019,'Smith'   ,'Olette','K' ,'CO',2)

Statement 49

INSERT INTO DWTIME VALUES(201,2019,09,29,3)

Statement 50

INSERT INTO DWTIME VALUES(202,2019,09,30,3)

Statement 51

INSERT INTO DWTIME VALUES(203,2019,09,31,3)

Statement 52

INSERT INTO DWTIME VALUES(206,2019,10,03,4)

Statement 53

INSERT INTO DWTIME VALUES(207,2019,10,04,4)

Statement 54

INSERT INTO DWSALESFACT VALUES(201,10014,'13-Q2/P2',1,14.99)

Statement 55

INSERT INTO DWSALESFACT VALUES(201,10014,'23109-HB',1,9.95)

Statement 56

INSERT INTO DWSALESFACT VALUES(201,10015,'54778-2T',2,4.99)

Statement 57

INSERT INTO DWSALESFACT VALUES(201,10015,'2238/QPD',1,38.95)

Statement 58

INSERT INTO DWSALESFACT VALUES(202,10016,'1546-QQ2',1,39.95)

Statement 59

INSERT INTO DWSALESFACT VALUES(202,10016,'13-Q2/P2',5,14.99)

Statement 60

INSERT INTO DWSALESFACT VALUES(202,10017,'54778-2T',3,4.99)

Statement 61

INSERT INTO DWSALESFACT VALUES(202,10017,'23109-HB',2,9.95)

Statement 62

INSERT INTO DWSALESFACT VALUES(202,10018,'PVC23DRT',12,5.87)

Statement 63

INSERT INTO DWSALESFACT VALUES(203,10012,'SM-18277',3,6.99)

Statement 64

INSERT INTO DWSALESFACT VALUES(203,10014,'2232/QTY',1,109.92)

Statement 65

INSERT INTO DWSALESFACT VALUES(203,10015,'23109-HB',1,9.95)

Statement 66

INSERT INTO DWSALESFACT VALUES(203,10015,'89-WRE-Q',1,256.99)

Statement 67

INSERT INTO DWSALESFACT VALUES(203,10016,'13-Q2/P2',2,14.99)

Statement 68

INSERT INTO DWSALESFACT VALUES(203,10016,'54778-2T',1,4.99)

Statement 69

INSERT INTO DWSALESFACT VALUES(203,10016,'PVC23DRT',5,5.87)

Statement 70

INSERT INTO DWSALESFACT VALUES(203,10017,'WR3/TT3',3,119.95)

Statement 71

INSERT INTO DWSALESFACT VALUES(203,10017,'23109-HB',1,9.95)

Statement 72

INSERT INTO DWSALESFACT VALUES(203,10017,'13-Q2/P2',1,14.99)

Statement 73

INSERT INTO DWSALESFACT VALUES(203,10018,'23109-HB',1,9.95)

Statement 74

INSERT INTO DWSALESFACT VALUES(203,10018,'54778-2T',2,4.99)

Statement 75

INSERT INTO DWSALESFACT VALUES(203,10018,'2238/QPD',1,38.95)

Statement 76

INSERT INTO DWSALESFACT VALUES(203,10019,'1546-QQ2',1,39.95)

Statement 77

INSERT INTO DWSALESFACT VALUES(206,10010,'13-Q2/P2',5,14.99)

Statement 78

INSERT INTO DWSALESFACT VALUES(206,10010,'54778-2T',3,4.99)

Statement 79

INSERT INTO DWSALESFACT VALUES(206,10010,'23109-HB',2,9.95)

Statement 80

INSERT INTO DWSALESFACT VALUES(206,10010,'PVC23DRT',12,5.87)

Statement 81

INSERT INTO DWSALESFACT VALUES(206,10011,'SM-18277',3,6.99)

Statement 82

INSERT INTO DWSALESFACT VALUES(206,10011,'2232/QTY',1,109.92)

Statement 83

INSERT INTO DWSALESFACT VALUES(206,10012,'23109-HB',1,9.95)

Statement 84

INSERT INTO DWSALESFACT VALUES(206,10012,'89-WRE-Q',1,256.99)

Statement 85

INSERT INTO DWSALESFACT VALUES(207,10013,'13-Q2/P2',2,14.99)

Statement 86

INSERT INTO DWSALESFACT VALUES(207,10013,'54778-2T',1,4.99)

Statement 87

INSERT INTO DWSALESFACT VALUES(207,10013,'PVC23DRT',5,5.87)

Statement 88

INSERT INTO DWSALESFACT VALUES(207,10014,'WR3/TT3',3,119.95)

Statement 89

INSERT INTO DWSALESFACT VALUES(207,10015,'23109-HB',1,9.95)

dwsalesfact

Additional Information