$20.00 Due In * 8 hours Homework Assignment 3 -
mek
Ch13-SaleCo-DW.zipDWDAYSALESFACT.csv
| P_CODE | SALE_UNITS | SALE_PRICE | TM_ID | CUS_CODE |
| 13-Q2/P2 | 1.0000000000000000e+00 | 1.4990000000000000e+01 | 201 | 10014 |
| 23109-HB | 1.0000000000000000e+00 | 9.9499999999999993e+00 | 201 | 10014 |
| 54778-2T | 2.0000000000000000e+00 | 4.9900000000000002e+00 | 201 | 10015 |
| 2238/QPD | 1.0000000000000000e+00 | 3.8950000000000003e+01 | 201 | 10015 |
| 1546-QQ2 | 1.0000000000000000e+00 | 3.9950000000000003e+01 | 202 | 10016 |
| 13-Q2/P2 | 5.0000000000000000e+00 | 1.4990000000000000e+01 | 202 | 10016 |
| 54778-2T | 3.0000000000000000e+00 | 4.9900000000000002e+00 | 202 | 10017 |
| 23109-HB | 2.0000000000000000e+00 | 9.9499999999999993e+00 | 202 | 10017 |
| PVC23DRT | 1.2000000000000000e+01 | 5.8700000000000001e+00 | 202 | 10018 |
| SM-18277 | 3.0000000000000000e+00 | 6.9900000000000002e+00 | 203 | 10012 |
| 2232/QTY | 1.0000000000000000e+00 | 1.0992000000000000e+02 | 203 | 10014 |
| 23109-HB | 1.0000000000000000e+00 | 9.9499999999999993e+00 | 203 | 10015 |
| 89-WRE-Q | 1.0000000000000000e+00 | 2.5699000000000001e+02 | 203 | 10015 |
| 13-Q2/P2 | 2.0000000000000000e+00 | 1.4990000000000000e+01 | 203 | 10016 |
| 54778-2T | 1.0000000000000000e+00 | 4.9900000000000002e+00 | 203 | 10016 |
| PVC23DRT | 5.0000000000000000e+00 | 5.8700000000000001e+00 | 203 | 10016 |
| WR3/TT3 | 3.0000000000000000e+00 | 1.1995000000000000e+02 | 203 | 10017 |
| 23109-HB | 1.0000000000000000e+00 | 9.9499999999999993e+00 | 203 | 10017 |
| 13-Q2/P2 | 1.0000000000000000e+00 | 1.4990000000000000e+01 | 203 | 10017 |
| 23109-HB | 1.0000000000000000e+00 | 9.9499999999999993e+00 | 203 | 10018 |
| 54778-2T | 2.0000000000000000e+00 | 4.9900000000000002e+00 | 203 | 10018 |
| 2238/QPD | 1.0000000000000000e+00 | 3.8950000000000003e+01 | 203 | 10018 |
| 1546-QQ2 | 1.0000000000000000e+00 | 3.9950000000000003e+01 | 203 | 10019 |
| 13-Q2/P2 | 5.0000000000000000e+00 | 1.4990000000000000e+01 | 206 | 10010 |
| 54778-2T | 3.0000000000000000e+00 | 4.9900000000000002e+00 | 206 | 10010 |
| 23109-HB | 2.0000000000000000e+00 | 9.9499999999999993e+00 | 206 | 10010 |
| PVC23DRT | 1.2000000000000000e+01 | 5.8700000000000001e+00 | 206 | 10010 |
| SM-18277 | 3.0000000000000000e+00 | 6.9900000000000002e+00 | 206 | 10011 |
| 2232/QTY | 1.0000000000000000e+00 | 1.0992000000000000e+02 | 206 | 10011 |
| 23109-HB | 1.0000000000000000e+00 | 9.9499999999999993e+00 | 206 | 10012 |
| 89-WRE-Q | 1.0000000000000000e+00 | 2.5699000000000001e+02 | 206 | 10012 |
| 13-Q2/P2 | 2.0000000000000000e+00 | 1.4990000000000000e+01 | 207 | 10013 |
| 54778-2T | 1.0000000000000000e+00 | 4.9900000000000002e+00 | 207 | 10013 |
| PVC23DRT | 5.0000000000000000e+00 | 5.8700000000000001e+00 | 207 | 10013 |
| WR3/TT3 | 3.0000000000000000e+00 | 1.1995000000000000e+02 | 207 | 10014 |
| 23109-HB | 1.0000000000000000e+00 | 9.9499999999999993e+00 | 207 | 10015 |
DWTIME.csv
TM_ID,TM_YEAR,TM_MONTH,TM_DAY,TM_QTR 201,2015,9,29,3 202,2015,,30,3 203,2015,9,31,3 206,2015,10,3,4 207,2015,10,4,4
DWVENDOR.csv
| V_CODE | V_NAME | V_AREACODE | V_STATE |
| 21225 | Bryson, Inc. | 615 | TN |
| 21226 | SuperLoo, Inc. | 904 | FL |
| 21231 | D\&E Supply | 615 | TN |
| 21344 | Gomez Bros. | 615 | KY |
| 22567 | Dome Supply | 901 | GA |
| 23119 | Randsets Ltd. | 901 | GA |
| 24004 | Brackman Bros. | 615 | TN |
| 24288 | ORDVA, Inc. | 615 | TN |
| 25443 | B\&K, Inc. | 904 | FL |
| 25501 | Damal Supplies | 615 | TN |
| 25595 | Rubicon Systems | 904 | FL |
DWPRODUCT.csv
| P_CODE | P_DESCRIPT | P_CATEGORY | V_CODE |
| 11QER/31 | Power painter, 15 psi., 3-nozzle | CAT1 | 25595 |
| 13-Q2/P2 | 7.25-in. pwr. saw blade | CAT1 | 21344 |
| 14-Q1/L3 | 9.00-in. pwr. saw blade | CAT1 | 21344 |
| 1546-QQ2 | Hrd. cloth, 1/4-in., 2x50 | CAT2 | 23119 |
| 1558-QW1 | Hrd. cloth, 1/2-in., 3x50 | CAT2 | 23119 |
| 2232/QTY | B\&D jigsaw, 12-in. blade | CAT2 | 24288 |
| 2232/QWE | B\&D jigsaw, 8-in. blade | CAT3 | 24288 |
| 2238/QPD | B\&D cordless drill, 1/2-in. | CAT3 | 25595 |
| 23109-HB | Claw hammer | CAT4 | 21225 |
| 23114-AA | Sledge hammer, 12 lb. | CAT4 | 21225 |
| 54778-2T | Rat-tail file, 1/8-in. fine | CAT1 | 21344 |
| 89-WRE-Q | Hicut chain saw, 16 in. | CAT2 | 24288 |
| PVC23DRT | PVC pipe, 3.5-in., 8-ft | CAT3 | 21225 |
| SM-18277 | 1.25-in. metal screw, 25 | CAT4 | 21225 |
| SW-23116 | 2.5-in. wd. screw, 50 | CAT2 | 21231 |
| WR3/TT3 | Steel matting, 4'x8'x1/6", .5" mesh | CAT3 | 25595 |
DWREGION.csv
| REG_ID | REG_NAME |
| 1 | NE |
| 2 | NW |
| 3 | SE |
| 4 | SW |
DWCUSTOMER.csv
| CUS_LNAME | CUS_FNAME | CUS_INITIAL | CUS_STATE | REG_ID | CUS_CODE |
| Ramas | Alfred | A | TN | 3 | 10010 |
| Dunne | Leona | K | GA | 3 | 10011 |
| Smith | Kathy | W | NY | 1 | 10012 |
| Olowski | Paul | F | NJ | 1 | 10013 |
| Orlando | Myron | CO | 2 | 10014 | |
| O'Brian | Amy | B | TN | 3 | 10015 |
| Brown | James | G | GA | 3 | 10016 |
| Williams | George | CA | 4 | 10017 | |
| Farriss | Anne | G | CA | 4 | 10018 |
| Smith | Olette | K | CO | 2 | 10019 |
