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

ID Number	Salesperson Name
103	Darwin
104	Kratz
201	Shulstad
319	Fortune
367	Wickert
388	Miller
435	Vick

Table 6-5 Glen Ross salespeople

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 the Table 6-6.

Sale Amount ($)	Commission Rate (%)
0 – 50,999	4
51,000 - 125,999	5
126,000 - 200,999	6
201,000 and up	7

Table 6-6 Glen Ross commission schedule

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