In the following problems, you will need to:

Define the problem by constructing a defining diagram

Create a solution algorithm using pseudocode

Problems:

A query is required to find the sales reps with a commission higher than $$100,$ order them ascending by name, and

report their name, address, and commission.

A query is required to find the sales reps for each customer and report the customer name, city, state, and sales rep

name.

A query is required to find the items in the category 'Dog', order them ascending by description, and report their

description, price, and quantity on hand.