3.) Create a trigger named trg_char_hours that will automatically update the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER tables CHAR_HOURS_FLOWN to update the AIRCRAFT tables AC_TTAF, AC_TTEL, and AC_TTER values. The meaning for the AIRCRAFT table columns are as follows:

AC_TTAF: Total time on the air frame

AC_TTEL: Total time on the left engine (Also used to record single engine hours)

AC_TTER: Total time on the right engine.

So in the trigger, you need to increase all of them with CHAR_HOUR_FLOWN

4.)Create a trigger named trg_cust_balance that will automatically update the CUSTOMER tables CUS_BALANCE when a new CHARTER row is added. Use the CHARTER tables CHAR_TOT_CHG as the update source (Assume that all charter charges are charged to the customer balance.) In addition to the CHAR_TOT_CHG, add $5 for every quart of oil used on the charter.

Table name: CHARTER OHAR TRP CHAR DATE AC NUMBER CHAR DESTNA TION CHAR DISTANCE CHAR HOURS, FLOWN CHAR HOURS WAIT CHAR.TYOT CH MAR OL QTS CUS CODE Database name: Ch08_AviaCo Table name: EARNEDRATING RTO CODE EARNRTO DATE 06-Feb-08 1 000 07-Feb-08 1484 10009 07-Feb 8228 07-Feb-08 1484PNA 0015 09-Feb-08 2289 10-Feb-08 1484P Table name: CREW Table name: CUSTOMER CUS 1285 19 Table name: RATING 10014 Orlando Mron RTG CODE Certified Fight Instructor, Instrument 10017 Wlia George Mutiengine Land Single Engine, Land Single Engine, Sea Table name: EMPLOYEE EMP EMP 15-Mar-1987 19-Mar-1965-Apr-1988 Table name: MODEL 14 Nov-1958 20-Dec-1992 6-0ct-1974 28Aug-2005 08Nov.1971 200 d.1996 PA23-250 Pper 4Mar-1975 0-Jan-2006 PA3-350 Piper Vandan Rhett ACTURER MOD NAME MOO SEATS MOO 105 M Willims Robert Navjo Chieftain Feb-1968 21-Aug-1974 02-1996 18-Nov-1994 110 Sras Legha Table name: AIRCRAFT Table name: PILOT MOD CODE AC TTAF AC TTEL AC TTEREMP 2438 768 79929 15131 18-Dec-0 05-Jan-0802-Jan-08 02-Feb-08 ATPISELMELISESAnstr CFI 22 Jan-08