Business
Engineering
Math
Science
Social Science
Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_ FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values.
BuyFindarrow_forward
Database Systems: Design, Implemen...
12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Solutions
Chapter
Section
BuyFindarrow_forward
Database Systems: Design, Implemen...
12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 8, Problem 41P
Textbook Problem
35 views
Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_ FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values.
Program Plan Intro
Trigger:
The trigger is a named set of SQL statement that is executed at the time of data modification or meets some data description.
- If the stated trigger condition meets up, then the mentioned action in the trigger has been performed.
There are three parts of trigger; they are:
Event:
- It specifies the change to be made, such as an UPDATE or DELETE of a record.
Condition:
- It specifies the condition to examine the records about to be affected. For each record, that meets the condition given in the trigger.
Action:
- The action performed after the start of the trigger.
The syntax to create a trigger is as given below:
CREATE TRIGGER trigger_name
{BEFORE| AFTER|INSTEAD OF} {INSERT|DELETE|UPDATE} ON
table_name
[FOR EACH{ROW|STATEMENT}] [WHEN(condition)]
<triggered SQL statement here>;
Explanation of Solution
Query to create trigger:
CREATE OR REPLACE TRIGGER TRG_CHAR_HOURS
AFTER INSERT ON CHARTER
FOR EACH ROW
BEGIN
UPDATE AIRCRAFT
SETAC_TTAF = AC_TTAF + :NEW.CHAR_HOURS_FLOWN,
AC_TTEL = AC_TTEL + :NEW.CHAR_HOURS_FLOWN,
AC_TTER = AC_TTER + :NEW.CHAR_HOURS_FLOWN
WHERE AIRCRAFT.AC_NUMBER = :NEW.AC_NUMBER;
END;
/
Explanation:
- The above query is used to create a trigger named “TRG_CHAR_HOURS” to update the “AC_TTAF”, “AC_TTEL”, “AC_TTEL” in the “AIRCRAFT” table whenever a record is inserted in the “CHARTER” table...
Chapter 8 Solutions
Database Systems: Design, Implementation, & Management
Show all chapter solutions
addCh. 8 - What is a cross join? Give an example of its...Ch. 8 - What three join types are included in the outer...Ch. 8 - Using tables named T1 and T2, write a query...Ch. 8 - What is a subquery, and what are its basic...Ch. 8 - What are the three types of results that a...Ch. 8 - What is a correlated subquery? Give an example.Ch. 8 - Explain the difference between a regular subquery...Ch. 8 - What does it mean to say that SQL operators are...Ch. 8 - The relational set operators UNION, INTERSECT, and...Ch. 8 - What is the difference between UNION and UNION...
Ch. 8 - Suppose you have two tables: EMPLOYEE and...Ch. 8 - Given the employee information in Question 11,...Ch. 8 - Given the employee information in Question 11,...Ch. 8 - Given the employee information in Question 11,...Ch. 8 - Why does the order of the operands (tables) matter...Ch. 8 - What MS Access and SQL Server function should you...Ch. 8 - What Oracle function should you use to calculate...Ch. 8 - Suppose a PRODUCT table contains two attributes,...Ch. 8 - What string function should you use to list the...Ch. 8 - What is a sequence? Write its syntax.Ch. 8 - What is a trigger, and what is its purpose? Give...Ch. 8 - What is a stored procedure, and why is it...Ch. 8 - What is embedded SQL and how is it used?Ch. 8 - What is dynamic SQL, and how does it differ from...Ch. 8 - Create the tables. (Use the MS Access example...Ch. 8 - Insert the data into the tables you created in...Ch. 8 - Write the query that will generate a combined list...Ch. 8 - Write the query that will generate a combined list...Ch. 8 - Write the query that will show only the duplicate...Ch. 8 - Write the query that will generate only the...Ch. 8 - Write the query to show the invoice number, the...Ch. 8 - Write the query for all the invoices that will...Ch. 8 - Write the query that will write Oracle sequences...Ch. 8 - Modify the CUSTOMER table to include two new...Ch. 8 - Assuming that you completed Problem 10, write the...Ch. 8 - Assuming that the CUSTOMER table contains a...Ch. 8 - Write the query that lists the average age of your...Ch. 8 - Write the trigger to update the CUST_BALANCE in...Ch. 8 - Write a procedure to add a new customer to the...Ch. 8 - Write a procedure to add a new invoice record to...Ch. 8 - Write a trigger to update the customer balance...Ch. 8 - Write a procedure to delete an invoice, giving the...Ch. 8 - Write a query to display the products that have a...Ch. 8 - Write a query to display the current salary for...Ch. 8 - Write a query to display the starting salary for...Ch. 8 - Write a query to display the invoice number, line...Ch. 8 - Write a single SQL command to increase all price...Ch. 8 - Write a query to display the customer code, first...Ch. 8 - LargeCo is planning a new promotion in Alabama...Ch. 8 - One of the purchasing managers is interested in...Ch. 8 - The purchasing manager is still concerned about...Ch. 8 - Create a trigger named trg_line_total to write the...Ch. 8 - Create a trigger named trg_line_prod that...Ch. 8 - Create a stored procedure named prc_inv_amounts to...Ch. 8 - Create a procedure named prc_cus_balance_update...Ch. 8 - Modify the MODEL table to add the attribute and...Ch. 8 - Write the queries to update the MOD_WAIT_CHG...Ch. 8 - Modify the CHARTER table to add the attributes...Ch. 8 - Write the sequence of commands required to update...Ch. 8 - Write the sequence of commands required to update...Ch. 8 - Write the command required to update the...Ch. 8 - Write the command required to update the...Ch. 8 - Write the command required to update the...Ch. 8 - Modify the PILOT table to add the attribute shown...Ch. 8 - Create a trigger named trg_char_hours that...Ch. 8 - Create a trigger named trg_pic_hours that...Ch. 8 - Create a trigger named trg_cust_balance that...Ch. 8 - Write a query to display all rows in the PATRON...Ch. 8 - Write a query to display the patron ID, book...Ch. 8 - Write a query to display the patron ID, patron...Ch. 8 - Write a query to display the book number, title...Ch. 8 - Write a query to display the author last name,...Ch. 8 - Write a query to display the author ID, book...Ch. 8 - Write a query to display the author last name,...Ch. 8 - Write a query to display the patron ID, book...Ch. 8 - Write a query to display the patron ID, full name...Ch. 8 - Write a query to display the book number and the...Ch. 8 - Write a query to display the author ID, first and...Ch. 8 - Write a query to display the book number, title,...Ch. 8 - Write a query to display the book number, title,...Ch. 8 - Write a query to display the book number, title,...Ch. 8 - Write a query to display the author ID, author...Ch. 8 - Write a query to display the patron ID, first and...Ch. 8 - Write a query to display the average number of...Ch. 8 - Write a query to display the patron ID and the...Ch. 8 - Write a query to display the book number, title,...Ch. 8 - Write a query to display the author ID, first and...Ch. 8 - Write a query to display the book number, title,...Ch. 8 - Write a query to display the book number, title,...Ch. 8 - Write a query to display the lowest average cost...Ch. 8 - Alter the DETAILRENTAL table to include a derived...Ch. 8 - Update the DETAILRENTAL table to set the values in...Ch. 8 - Alter the VIDEO table to include an attribute...Ch. 8 - Update the VID_STATUS attribute of the VIDEO table...Ch. 8 - Alter the PRICE table to include an attribute...Ch. 8 - Update the PRICE table to place the values shown...Ch. 8 - Create a sequence named rent_num_seq to start with...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Show solutions addDefine each of the following terms: a. data b. field c. record d. file
Database Systems: Design, Implementation, & Management
Identify and briefly discuss the six processes that comprise knowledge management.
Fundamentals of Information Systems
Honeywell reported that is increased team productivity by 20 percent and reduced requirements errors by 10 perc...
Fundamentals of Information Systems
List two operators that you can use with subqueries as an alternate way of performing joins.
A Guide to SQL
What is steganography, and what can it be used for?
Principles of Information Security (MindTap Course List)
If an X-bar chart graph is between LCL and the UCL, a machining process is said to be ____________.
Precision Machining Technology (MindTap Course List)
Do research to learn more about GEs Change Acceleration Management process. Prepare a slide presentation that s...
Principles of Information Systems (MindTap Course List)
Following are the results of a sieve analysis: a. Determine the percent finer than each sieve size and plot a g...
Fundamentals of Geotechnical Engineering (MindTap Course List)
Problem 2-59A Journalizing Transactions Monroe Company rents and sells electronic equipment. During September, ...
Cornerstones of Financial Accounting
What is particulate matter and when is it produced?
Automotive Technology: A Systems Approach (MindTap Course List)
Plot the functions, y = x, y = 10x and y = log x. Vary the x value from 1 to 3. Is the function y = log x a mir...
Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
Three groups of students from the Geotechnical Engineering class collected soil-aggregate samples for laborator...
Principles of Geotechnical Engineering (MindTap Course List)
The continuous frame ABC has a pin support at /l, roller supports at B and C, and a rigid corner connection at ...
Mechanics of Materials (MindTap Course List)
Based on your reading of the chapter and what you now know about the issues, list at least three other things C...
Management Of Information Security
You are creating a system for a bowling alley to manage information about its leagues. During the modeling proc...
Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)
The forces acting on the bob of the pendulum are its weight W(w=2lb) and the tension T in the cord. When the pe...
International Edition---engineering Mechanics: Statics, 4th Edition
Calorie (energy) and horsepower (power) are two non-SI units that you might see on occasion. A. Death Valley Na...
Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)
The speed of a synchronous motor is fixed by the a. rotor winding. b. amortisseur winding. c. supply voltage. d...
Electric Motor Control
In general, systems are required to be grounded if the maximum voltage to ground does not exceed: (Circle the c...
EBK ELECTRICAL WIRING RESIDENTIAL
What would be three good uses for methane collected from a landfill?
Solid Waste Engineering
Which of the following is not a true statement about thermostats? Faulty thermostats are often the cause of air...
Automotive Technology
A plate is used as a bracket and is attached to a column flange, as shown in Figure P8.2-3. Use an elastic anal...
Steel Design (Activate Learning with these NEW titles from Engineering!)
If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?
A+ Guide to Hardware (Standalone Book) (MindTap Course List)
The power supply converts the wall outlet AC power into DC power. (301)
Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
What three characteristics about TCP distinguish it from UDP?
Network+ Guide to Networks (MindTap Course List)
List some applications that use high-pressure piping.
Welding: Principles and Applications (MindTap Course List)
