11. Use the attributes shown in Figure P3.17 and write the data dictionary using the format shown in Table P3.22. Table name: PRODUCT Primary key: PROD_CODE Foreign key: VEND_CODE PROD_CODE PROD DESCRIPTION 12-VWP2 725-in power saw blade 2.5-in. wood screw, 100 PVC pipe, 3.5-in., 8 ft. Rat-tail file, 0.125-in, fine 10023-55 231-78-W 33564/U AR/3/TYR Cordless drill, 0.25-in. DT-34-WWW Phillips screwdriver pack EE3-67AV Sledge hammer, 12 lb. Houselite chain saw, 16-in. ER-56.OF FRE-TRY9 Jigsaw, 12-in blade SE-67-89 Jigsaw, 8-in, blade ZW-GRIAV Hardware cloth, 0.25-in. ZX-WR/FR Claw hammer Table name: VENDOR Primary key: VEND_CODE Foreign key: none VEND_CODE VEND NAME 120 BargainSnapper, Inc. 121 Cutholow Co. 122 Rip & Rattle Supply Co. 123 Tools R Us 124 Trowel & Dowel, Inc. 125 Bow & Wow Tools Table Name Database name: Ch03_Cheap Co PROD STOCK DATE PROD_ON HAND PROD PRICE VEND CODE 07-Apr-08 1.19 19-Mar-08 07-Dec-07 08-Mar-08 29-Nov-07 20-Dec-07 25-Feb-08 28-Dec-07 12-Aug-07 11-Oct-07 Table P3.22 The Data Dictionary Attribute Name 23-Apr-08 01-Mar-08 VEND CONTACT Melanie T. Travis Contents Type 12 123 45 18 8 Length Format 11 9 7 67 34 14 15 VEND AREACODE VEND PHONE 615 899-1234 615 342-9096 Henry J. Olero Anne R. Morrins 901 225-1127 546-7894 Julette O. McHervy 615 George F. Frederick 901 BS Sedwick 904 8.87 1.19 45.99 23.29 17.99 235.49 453-4567 324-9988 1.45 1.35 12.99 8.95 Range Req'd Key 123 123 121 123 121 123 22 121 125 125 125 123 121 Referenced Table