Glen Ross Vacation Property Sales employs seven salespeople, as shown in Table 6-8. When...

Glen Ross Vacation Property Sales employs seven salespeople, as shown in Table 6-8. When a salesperson makes a sale, a record is created, including the date, time, and dollar amount of the sale. The time is expressed in hours and minutes, based on a 24-hour clock. The sale amount is expressed in whole dollars. Salespeople earn a commission that differs for each sale, based on the rate schedule in Table 6-9.

Design an application that produces each of the following:

a. A list of each salesperson number, name, total sales, and total commissions

b. A list of each month of the year as both a number and a word (for example, 01 January), and the total sales for the month for all salespeople

c. A list of total sales as well as total commissions earned by all salespeople for each of the following time frames, based on hour of the day: 00–05, 06–12, 13–18, and 19–23