CIS 515 STUDY Future Starts Here/cis515study.com CIS 515 STUDY Future Starts Here/cis515study.com | Page 17

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:
•Be typed, double spaced, using Times New Roman font (size 12),
with one-inch margins on all sides; citations and references must
follow APA or school-specific format. Check with your professor for
any additional instructions.
•Include a cover page containing the title of the assignment, the
student’s name, the professor’s name, the course title, and the date.
The cover page and the reference page are not included in the
required assignment page length.
•Include charts or diagrams created in Excel, Visio, MS Project, or
one of their equivalents such as Open Project, Dia, and Open
Office. The completed diagrams / charts must be imported into the
Word document before the paper is submitted