Question: Please type answer and please answer it correctly. 44 and 45 of MY SQL Problems 8.44-8.46 Create a trigger named trg_char_hours that automatically updates the
Please type answer and please answer it correctly. 44 and 45 of MY SQL

Problems 8.44-8.46 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.) Task Complete Problem 44 above. Problem 45 Create a trigger named trg-pic_hours that automatically updates the PILOT table when a new CREW row is added and the CREW table uses a Pilot CREW_JOB entry. Use the CHARTER table's CHAR_HOURS_FLOWN to update the PILOT table's PIL_PIC_HRS only when the CREW table uses a Pilot CREW_JOB entry. Task
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
