CIS 515 Course Great Wisdom / tutorialrank.com CIS 515 Course Great Wisdom / tutorialrank.com | Page 18

graphically depicted solution is not included in the required page
length.

2.Construct a query that can be used on a report for determining how
many days the customer’s invoice will require payment if total
amount due is within 45 days. Provide a copy of your working code
as part of the paper.

3.Using the salesperson table described in the summary above,
complete the following:

a.Construct a trigger that will increase the field that holds the total
number of tours sold per salesperson by an increment of one (1).

b.Create a query that can produce results that show the quantity of
customers each salesperson has sold tours to.

4.Support the reasoning behind using stored procedures within the
database as an optimization process for the database transactions.

Your assignment must follow these formatting requirements: