Refer to Figure 4-5. For each of the following reports (with sample data), indicate any indexes that you feel would help the report run faster as well as the type of index:
a. State, by products (user-specified period)

b. Most frequently sold product finish in a user-specified month.

c. All orders placed last month.

d. Total product sold, by product line (use-specified period)

Transcribed Image Text:

State, by Products Report, January 1, 2015, to March 31, 2015 State co Co CO cO NY VA Product Description oal Quantity Ordered 8-Drawer Dresser Entertainment Center Oak Computer Desk Writer's Desk Writer's Desk Writer's Desk 0 Most Frequently Sold Product Finish Report, March 1, 2015, to March 31, 2015 Product Finish Units Sold 13 Cherry Monthly Order Report, March 1, 2015, to March 31, 2015 Order ID Order Date Customer ID Customer Name 19 3/5/15 Eastern Furniture Associated Order Details: Quantity Extended Price Product DescriptionOrdered Cherry End Table High Back Leather Chair Price 575.00 $362.00 $1,810.00 10 $750.00 Customer Name Contemporary Casuals Order ID Order Date Customer IDs 24 3/10/15 Associated Order Details: Quantity Product Description Ordered Price Extended Price Bookcase 4 $69.00 $276.00 Products Sold by Product Line, March 1, 2015, to March 31, 2015 Product Line Basic Antique Modern Classical Quantity Sold 200 15 10 75