11. Use the attributes shown in Figure P3.17 and write the data dictionary using the format...

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

This data dictionary outlines the attributes their descriptions data types lengths formats whether t... View the full answer