Question: Using SQL complete Exercise 8 SQL Functions and Procedures 8. Assume the TRIP table contains a column named TOTAL PERSONS that represents the total number

Using SQL complete Exercise 8

the TRIP table contains a column named TOTAL PERSONS that represents the

total number of persons for that trip. Following the style shown in

the text, write the code in PL/SQL or T-SQL for the following

triggers: When inserting a row in the RESERVATION table, add the NUM_PERSONS

value to the TOTAL PERSONS value for the appropriate trip. a. b.

SQL Functions and Procedures 8. Assume the TRIP table contains a column named TOTAL PERSONS that represents the total number of persons for that trip. Following the style shown in the text, write the code in PL/SQL or T-SQL for the following triggers: When inserting a row in the RESERVATION table, add the NUM_PERSONS value to the TOTAL PERSONS value for the appropriate trip. a. b. When updating a row in the RESERVATION table, add the difference between the new NUM PERSONS value and the old NUM PERSONS value to the TOTAL PERSONS value for the appropriate trip. When deleting a row in the RESERVATION table, subtract the NUM_PERSONS value from the TOTAL_PERSONS value for the appropriate trip. c. Because the TRIP table contains several columns with character data, the staff at Colo- duanture Tours would like to know more about string or character functions. Use the TD ond INITCAP. Are

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To create the specified triggers we will need to write SQL code using a procedural extension like PLSQL for Oracle databases or TSQL for SQL Server Be... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using SQL complete Exercise 9 a. Wh -SOL for the following triggers en inserting a row in TAL PERSO the RESERVATION table, add the NUM PERSONS value to RESERVATIo value for the appropriate trip...

Complete the Colonial Adventure Tours Exercises 1-4 u lo tourth specifik only have one supervisor u s his woman S is considering changing urth normal form Client Lue . La Raupervis , Buper cu supood...

SQL code 1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view. 2. Create a...

Use SQL and Colonial Adventure Tour database to complete the following Exercises SQL Functions and Procedures total number of persons for that the s in PL/SQL or T-SQL for the following triggers: e...

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

Suppose that R(A, B, C) is a relational schema with functional dependencies F = {A, B C, C B}. (i) Is this schema in 3NF? Explain. [2 marks] (ii) Is this schema in BCNF? Explain. [2 marks] (b)...

Contrast the impacts of homologous and nonhomologous recombination on the evolution of the core genome and the pan genome.

Shannon has developed a new type of space heater that is quieter and safer than previous generations of space heaters and is particularly geared to people who live in small spaces, such as apartments...

2 Popsquash plc is one of the world's largest makers of soft drinks. Sales have increased in recent years but profits have not. Rising fixed and variable costs have meant that higher sales revenue...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...