E6.5 Show the PRODUCT table from Figure 3.33 in Chapter 3 accompanied by a PRODUCTNAME_INDEX table, using the ProductID value as the index pointer.

INCLUDES m VENDOR VendorID ProductID TID Vendor Name REGION RegionID RegionName Chicagoland . Tristate Quantity 1 1X1 T111 PG Pacifica Gear Mountain King 2X2 T222 1 MK T333 5 3X3 1X1 T333 1 4X4 1 STORE StoreID StoreZip S1 60600 S2 60605 S3 35400 RegionID T444 T444 CATEGORY CategoryID CategoryName CP Camping FW Footwear 2 2x2 4X4 T555 4 T 5X5 T555 2 6X6 T555 1 CUSTOMER SALESTRANSACTION TID Customer ID T111 1-2-333 T222 2-3-444 T333 1-2-333 StoreID S1 TDate 1-Jan-2020 CustomerID S2 1-Jan-2020 2-Jan-2020 CustomerName Customer Zip Tina 60137 Tony 60611 Pam 35401 1-2-333 2-3-444 3-4-555 S3 T444 S3 2-Jan-2020 3-4-555 2-3-444 T555 S3 2-Jan-2020 PRODUCT ProductID 1X1 CategoryID CP 2x2 FW 3X3 ProductName ProductPrice VendorID Zzz Bag $100 PG Easy Boot $70 MK Cosy Sock $15 MK Dura Boot $90 PG Tiny Tent $150 MK Biggy Tent $250 FW 4X4 FW CP 5X5 6X6 MK CP Figure 3.33 Sample data records for the ZAGI Retail Company Sales Department Database shown in Figure 3.32 INCLUDES m VENDOR VendorID ProductID TID Vendor Name REGION RegionID RegionName Chicagoland . Tristate Quantity 1 1X1 T111 PG Pacifica Gear Mountain King 2X2 T222 1 MK T333 5 3X3 1X1 T333 1 4X4 1 STORE StoreID StoreZip S1 60600 S2 60605 S3 35400 RegionID T444 T444 CATEGORY CategoryID CategoryName CP Camping FW Footwear 2 2x2 4X4 T555 4 T 5X5 T555 2 6X6 T555 1 CUSTOMER SALESTRANSACTION TID Customer ID T111 1-2-333 T222 2-3-444 T333 1-2-333 StoreID S1 TDate 1-Jan-2020 CustomerID S2 1-Jan-2020 2-Jan-2020 CustomerName Customer Zip Tina 60137 Tony 60611 Pam 35401 1-2-333 2-3-444 3-4-555 S3 T444 S3 2-Jan-2020 3-4-555 2-3-444 T555 S3 2-Jan-2020 PRODUCT ProductID 1X1 CategoryID CP 2x2 FW 3X3 ProductName ProductPrice VendorID Zzz Bag $100 PG Easy Boot $70 MK Cosy Sock $15 MK Dura Boot $90 PG Tiny Tent $150 MK Biggy Tent $250 FW 4X4 FW CP 5X5 6X6 MK CP Figure 3.33 Sample data records for the ZAGI Retail Company Sales Department Database shown in Figure 3.32