1. Which tables and fields would you access to determine which ISBN numbers of the books have been purchased by a customer and what is the cost to ship the order? 2. How would you find out which books do not have any discount? 3. Which tables and fields need to be accessed to determine the total sales of all Computer books ordered in March of 2009? 4. How much profit is generated from orders that were placed in October, November and December of 2009. Remember to take in consideration that some books are ordered in multiple copies and profit is determined by the difference in retail price of the book and its cost. Also, some books on orders have discount. 5. Customer wants to know about the book published in 2005 by author Robinson. What is the access path (all tables and columns) to follow to find the list?

FIGURE 1-5 JustLee Books's table structures after normalization