CIS 515 Week 7 Assignment 6 Sql Concepts And Database Design ( 2 Papers )
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
=====================================================================================
CIS 515 Week 7 Assignment 6 Sql Concepts And Database Design ( 2 Papers )
FOR MORE CLASSES VISIT www . cis515study . com