Assignment 5 tour operator agency database 11 the

This preview shows page 11 - 14 out of 14 pages.

Assignment 5: Tour Operator Agency Database 11 The increasing of the field that holds the total number of tours sold per salesperson by an increment of one (1): We can increase the number of sold number by using the following query: SELECT SOLDNUMBER, FROM PUBLIC.TOURSOLD, WHERE SOLDNUMBER+1; The query that can produce results that show the customers each salesperson has sold tours to:
Assignment 5: Tour Operator Agency Database 12 We can find the All information about any customer who buy from the tours by the using ( INNER JOIN ), as the following: SELECT SalesPersons.EmpID, SalesPersons.FirstName, SalesPersons.LastName, SalesPersons.TourID FROM ToursSold INNER JOIN SalesPersons ON ToursSold.TourID = SalesPersons.TourID ORDER BY SalesPersons.TourID; The reasoning behind using stored procedures within the database as an optimization process for the database transactions: A stored procedure is the procedures and statements of the SQL, and it is stored in the database. The stored procedure has many advantages such as the following: It prevents the
Assignment 5: Tour Operator Agency Database 13 recurrence of the transactions, then it reduces the network traffic, and it minimizes the errors, then reduces the costs and maximize the performance. ( Coronel, C., 2010). The levels of any operations are completed before the operation are ended; this process is done in multiple systems by the Transactions. The transactions in the SQL language are performed by the stored procedure. The stored procedure enhances the transactions in SQL to be faster, more efficient, and without any duplication. The transaction begins inside the stored procedure, then all the transactions (which inside the many stored procedures) are invoked

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture