$20.00 Due In * 8 hours Homework Assignment 3 -
mek
Ch13-SaleCo-DW.mdb| 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 |
| P_CODE | SALE_UNITS | SALE_PRICE | TM_ID | CUS_CODE |
|---|---|---|---|---|
| 13-Q2/P2 | 1.0 | 14.99 | 201 | 10014 |
| 23109-HB | 1.0 | 9.95 | 201 | 10014 |
| 54778-2T | 2.0 | 4.99 | 201 | 10015 |
| 2238/QPD | 1.0 | 38.95 | 201 | 10015 |
| 1546-QQ2 | 1.0 | 39.95 | 202 | 10016 |
| 13-Q2/P2 | 5.0 | 14.99 | 202 | 10016 |
| 54778-2T | 3.0 | 4.99 | 202 | 10017 |
| 23109-HB | 2.0 | 9.95 | 202 | 10017 |
| PVC23DRT | 12.0 | 5.87 | 202 | 10018 |
| SM-18277 | 3.0 | 6.99 | 203 | 10012 |
| 2232/QTY | 1.0 | 109.92 | 203 | 10014 |
| 23109-HB | 1.0 | 9.95 | 203 | 10015 |
| 89-WRE-Q | 1.0 | 256.99 | 203 | 10015 |
| 13-Q2/P2 | 2.0 | 14.99 | 203 | 10016 |
| 54778-2T | 1.0 | 4.99 | 203 | 10016 |
| PVC23DRT | 5.0 | 5.87 | 203 | 10016 |
| WR3/TT3 | 3.0 | 119.95 | 203 | 10017 |
| 23109-HB | 1.0 | 9.95 | 203 | 10017 |
| 13-Q2/P2 | 1.0 | 14.99 | 203 | 10017 |
| 23109-HB | 1.0 | 9.95 | 203 | 10018 |
| 54778-2T | 2.0 | 4.99 | 203 | 10018 |
| 2238/QPD | 1.0 | 38.95 | 203 | 10018 |
| 1546-QQ2 | 1.0 | 39.95 | 203 | 10019 |
| 13-Q2/P2 | 5.0 | 14.99 | 206 | 10010 |
| 54778-2T | 3.0 | 4.99 | 206 | 10010 |
| 23109-HB | 2.0 | 9.95 | 206 | 10010 |
| PVC23DRT | 12.0 | 5.87 | 206 | 10010 |
| SM-18277 | 3.0 | 6.99 | 206 | 10011 |
| 2232/QTY | 1.0 | 109.92 | 206 | 10011 |
| 23109-HB | 1.0 | 9.95 | 206 | 10012 |
| 89-WRE-Q | 1.0 | 256.99 | 206 | 10012 |
| 13-Q2/P2 | 2.0 | 14.99 | 207 | 10013 |
| 54778-2T | 1.0 | 4.99 | 207 | 10013 |
| PVC23DRT | 5.0 | 5.87 | 207 | 10013 |
| WR3/TT3 | 3.0 | 119.95 | 207 | 10014 |
| 23109-HB | 1.0 | 9.95 | 207 | 10015 |
| 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 |
| REG_ID | REG_NAME |
|---|---|
| 1 | NE |
| 2 | NW |
| 3 | SE |
| 4 | SW |
| 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 |
| 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 |
