Helen Jarvis wants to determine the most important customers for Home Office products. S...

Helen Jarvis wants to determine the most important customers for Home Office products. She requests a listing of total dollar sales year-to-date for each customer who bought these products, as revealed by invoiced payments. The list is to be sorted in descending order, so that the largest customer heads the list.

a. Look at Figure 1-15 and determine what entities are required to produce this list.

b. Which entities will be involved in the SQL query that will give Helen the information she needs?

FIGURE 1-15 Project data model for Home Office product line marketing support system