CIS 515 STUDY Great Stories/cis515study.com CIS 515 STUDY Great Stories/cis515study.com | Page 18

an open source alternative such as Dia. Note: The 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.