PRODUCT table: Column Name Data Type Nullable Default Primary Key P_CODE VARCHAR2(10) No - 1 P_DESCRIPT VARCHAR2(35) No - - P_INDATE DATE No - - P_ONHAND NUMBER No - - P_MIN NUMBER No - - P_PRICE NUMBER(8,2) No - - P_DISCOUNT NUMBER(5,2) No - - V_CODE NUMBER Yes - - P_CODE P_DESCRIPT P_INDATE P_ONHAND P_MINP_PRICE P_DISCOUNT V_CODE 11QER/31 Power painter, 15 psi., 3-nozzle 03-DEC-01 8 5 109.99 0 25595 13-Q2/P2 7.25-in. pwr. saw blade 13-JAN-02 32 15 14.99 .05 21344 14-Q1/L3 9.00-in. pwr. saw blade 13-JAN-02 18 12 17.49 0 21344 1546-QQ2 Hrd. cloth, 1/4-in., 2x50 15-DEC-01 15 8 39.95 0 23119 1558-QW1 Hrd. cloth, 1/2-in., 3x50 15-JAN-02 23 5 43.99 0 23119 2232/QTY B&D jigsaw, 12-in. blade 30-DEC-01 8 5 109.92 .05 24288 2232/QWE B&D jigsaw, 8-in. blade 24-JAN-02 6 5 99.87 .05 24288 2238/QPD B&D cordless drill, 1/2-in. 20-NOV-01 12 5 38.95 .05 25595 23109-HB Claw hammer 20-JAN-02 23 10 9.95 .1 21225 23114-AA Sledge hammer, 12 lb. 02-FEB-02 8 5 14.4 .05 - 54778-2T Rat-tail file, 1/8-in. fine 15-JAN-02 43 20 4.99 0 21344 89-WRE-Q Hicut chain saw, 16 in. 07-DEC-01 11 5 256.99 .05 24288 PVC23DRT PVC pipe, 3.5-in., 8-ft 20-JAN-02 188 75 5.87 0 - SM-18277 1.25-in. metal screw, 25 29-DEC-01 172 75 6.99 0 21225 SW-23116 2.5-in. wd. screw, 50 24-DEC-01 237 100 8.45 0 21231 WR3/TT3 Steel matting, 4'x8'x1/6", .5" mesh 17-JAN-02 18 5 119.95 .1 25595 ********************************************************* VENDOR table: Column Name Data Type Nullable Default Primary Key V_CODE NUMBER No - 1 V_NAME VARCHAR2(35) No - - V_CONTACT VARCHAR2(15) No - - V_AREACODE CHAR(3) No - - V_PHONE CHAR(8) No - - V_STATE CHAR(2) No - - V_ORDER CHAR(1) No - - V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 21225 Bryson, Inc. Smithson 615 223-3234 TN Y 21226 SuperLoo, Inc. Flushing 904 215-8995 FL N 21231 D&E Supply Singh 615 228-3245 TN Y 21344 Gomez Bros. Ortega 615 889-2546 KY N 22567 Dome Supply Smith 901 678-1419 GA N 23119 Randsets Ltd. Anderson 901 678-3998 GA Y 24004 Brackman Bros. Browning 615 228-1410 TN N 24288 ORDVA, Inc. Hakford 615 898-1234 TN Y 25443 B&K, Inc. Smith 904 227-0093 FL N 25501 Damal Supplies Smythe 615 890-3529 TN N 25595 Rubicon Systems Orton 904 456-0092 FL Y