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. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Textbook: Digital Systems
Chapter 8
Question/Problem 44
I'm not sure if I'm running the correct Query for this problem.
The question is:
"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.
(Hint: use temp values, as the INSERT event does not accept the OLD keyword.)"
I ran this query without any errors:
Expert Answer
Actually, given information is
"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.
Step 2
AS
BEGINUPDATE AIRCRAFT
SET
AC_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;
COMMIT;
END;
/
2.
DELIMITER </strong></p><p><strong>CREATEORREPLACEPROCEDUREUPDATEMODELCHARGE(MODELNOINMODEL.MODCODE%TYPE)</strong></p><p><strong>BEGIN</strong></p><p><strong>UPDATEMODELSETMODCHGMLE=1.20*MODCHGMLEWHEREMODEL.MODCODE=MODELNO;</strong></p><p><strong>COMMIT;</strong></p><p><strong>END</strong></p> <p><strong>CREATE OR REPLACE PROCEDURE UPDATE_MODEL_CHARGE (MODEL_NO IN MODEL.MOD_CODE%TYPE)</strong></p> <p><strong>BEGIN</strong></p> <p><strong>UPDATE MODEL SET MOD_CHG_MLE = 1.20 * MOD_CHG_MLE WHERE MODEL.MOD_CODE = MODEL_NO;</strong></p> <p><strong>COMMIT;</strong></p> <p><strong>END
DELIMITER ;
But this answer is also incorrect. I attached a second screcond of Expert solution.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
