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