Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text’s Web site (or create the set of relational tables in Table 4-5 in any relational DBMS product to which you have access). Write queries to answer the following questions. Note: For some of these questions you may have to create two queries—one to calculate a total such as invoice total and the second to answer the question asked.

a. How many different kinds of inventory items does S&S sell?

b. How many sales were made during October?

c. What were total sales in October?

d. What was the average amount of a sales transaction?

e. Which salesperson made the largest sale?

f. How many units of each product were sold?

g. Which product was sold most frequently?