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

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.

Create a stored procedure to update model charge per mile attribute. Procedure takes the model number as a parameter. The procedure increases the charge for this model by 20%.

Create a stored procedure that will take an Employee number and percentage, then update the corresponding employees hourly salary by the input percentage (increase the hourly salary, so you are giving the employee a raise). Hint: you may have to do some additional work on this one to get the table correct.

?5ample Report for Elabox Homework 5-ics 311-C ? The course oerview \G Home lCheggcom bubraryl Dashboard x CSecr https://metrostate learn.minnstate edu/d2le/content/391816/viewContent/32 Database hame: Ch08 AviaCo Table name: EARNEDRATING Table name: CHARTER Table name: CREW Table name: CUSTOMER 129Table name: RATING Table name: EMPLOYEE '???-1985 25-Apr-1555 Table name: MODEL Table name: AIRCRAFT Table name: PILOT 122 1 2432 Download the file named "assignment5_database.sql" from 1)21 Run the file from MySQL command window using the command (assuming the file is stored under c:t): a, 2 3 BVewa Text 141 PM O Type here to search ?5ample Report for Elabox Homework 5-ics 311-C ? The course oerview \G Home lCheggcom bubraryl Dashboard x CSecr https://metrostate learn.minnstate edu/d2le/content/391816/viewContent/32 Database hame: Ch08 AviaCo Table name: EARNEDRATING Table name: CHARTER Table name: CREW Table name: CUSTOMER 129Table name: RATING Table name: EMPLOYEE '???-1985 25-Apr-1555 Table name: MODEL Table name: AIRCRAFT Table name: PILOT 122 1 2432 Download the file named "assignment5_database.sql" from 1)21 Run the file from MySQL command window using the command (assuming the file is stored under c:t): a, 2 3 BVewa Text 141 PM O Type here to search