Chapter 5, Problem 5.51PAE

Refer to Figure 4-5 0. 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)
State, by Products Report, January 1, 2018, to March 31, 2018

State	Product Description	Total Quantity Ordered
CO	8-Drawer Dresser	1
CO	Entertainment Center	0
co	Oak Computer Desk	1
co	Writer’s Desk	2
NY	Writer’s Desk	1
VA	Writer’s Desk	5

b. Most frequently sold product finish in a user-specified month
Most Frequently Sold Product Finish Report, March 1, 2018, to March 31, 2018

Product Finish	Units Sold
Cherry	13

c. All orders placed last month
Monthly Order Report, March 1, 2018, to March 31, 2018

Order Id	Order Date	Customer Id	Customer Name
19	3/5/18	4	Eastern Furniture

Associated Order Details

Product Description	Quantity Ordered	Price	Extended Price
Cherry End Table	10	$75.00	$750.00
High Back Leather Chair	5	$362.00	$1,810.00

Order Id	Order Date	Customer Ids	Customer Name
24	3/10/18	1	Contemporary Casuals

Associated Order Details

Product Description	Quantity Ordered	Price	Extended Price
Bookcase	4	$69.00	$276.00

d. Total products sold, by product line (user-specified period)
Products Sold by Product Line, March 1, 2018, to March 31, 2018

Product Line	Quantity Sold
Basic	200
Antique	15
Modern	10
Classical	75