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?

Transcribed Image Text:

CUSTOMER PRODUCT LINE Customer ID Customer Name Customer Type Customer Zip Code Customer Years Product Line Name PL Prior Years Sales Goal PL Current Years Sales Goal Includes Places ORDER LINE Order Number Product ID Order Quantity ORDER PRODUCT Order Number Order Placement Date Order Fulfillment Date Order Number of Shipments Contains Has Product ID Product Description Product Finish Product Standard Price Product Cost PR Prior Years Sales Goal PR Current Year Sales Goal is billed on INVOICE PAYMENT Is paid on Invoice Number Order Number Invoice Date Payment Date Payment Amount