1. Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped?

2. How would you determine which orders have not yet been shipped to the customer?

3. If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this information?

4. Explain how you would determine how much profit was generated from orders placed in April 2009.

5. If a customer inquired about a book written in 2003 by an author named Thompson, which access path (tables and fields) would you need to follow to find the list of books meeting the customers request?

Figure 1-5. CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKAUTHOR AUTHOR BOOKS ISBN ISBN DOWN AuthorID AuthorID Lname Title Fname Pubdate PublD Cost Retail Discount Category PUBLISHER PublD Name PROMOTION Contact Phone Gift Minretail Maxretail JustLee Books's table structures after normalization