Attribute name Attribute Descri Attribute t each model can lift Question 1: Triggers and Stored Procedures: Database nama: C AviaCo Oace the attribute has been added, update the values of all rows as per following ttribute values for MOD LIFT WEIGHT ,000 fo MAT (4 Points) Create a trigge naned tg chater haura that will automatically update the AIRCRAFT table after a new CHARTER row 1s added Use the CHARTER table's CHAR HOURS_FLOWN to update the AIRCRAFT table's AC TTAF, AC TTEL and AC TTER values. 3) Table nana Table name: RATING The meaning for the AIRCRAFT table coluanns are as follows: AC ITAF: Totaltine on the a frame AC TIEL: Total time oa tbe left engine (Also used to record single engine hours) AC TIER: Total time on the right engine. Table name Tabile name So in the tuigge, you need to increase all of them with value of CHAR HOURS FLOWN 4) (4 Points) Create trigger narned tEB_caa alapig that will automatically update the AC CUSTOMER table's CUS BALANCE before a ne CHARTER 1ow is added. Use the CHARTER table's CHAR TOT CHG as the update source (Assume that all charter charges ae charged to the custoae balan.) In addition to the CHAR_TOT CHG, add $25 for every quart of oil used on the charter ARCRAFT Answer the following questions based on the above database: 5) 4 Points) Create a stored procedure to update model charge per mile attrbute Procecure takes the model number as a parameter. The procedure increases the charge for this model by 25%. 1) (4 Points) Create a view named "ATL_CHARTERS_ that includes the following For each charter of aircraft to Atlanta (STL), print the charter date, charter hours flown, and the coresponding custouner last name, first name, area code, and phone number" Your answer should inchude both the SQL statement for view creating along with the contents of the view (von get the contents of the view by select from ATL-CHARTERS_). 6) (4 Points) Create a stored procedure that will take an Employee number and percentage, then update the corresponding employee's hourly salary by the input percentage increase the hourly salary, so you are giving the employee a raise). Hint: Ate Employee table to add the houri salafeld, pdate it with a value of 30 for all rowsin the table, bafore creating theprocedure. 2) (4 Points) Modify the MODEL table to add the following attribute: (Note: use ALTER TABLE and UPDATE coammands fox this Attribute name Attribute Descri Attribute t each model can lift Question 1: Triggers and Stored Procedures: Database nama: C AviaCo Oace the attribute has been added, update the values of all rows as per following ttribute values for MOD LIFT WEIGHT ,000 fo MAT (4 Points) Create a trigge naned tg chater haura that will automatically update the AIRCRAFT table after a new CHARTER row 1s added Use the CHARTER table's CHAR HOURS_FLOWN to update the AIRCRAFT table's AC TTAF, AC TTEL and AC TTER values. 3) Table nana Table name: RATING The meaning for the AIRCRAFT table coluanns are as follows: AC ITAF: Totaltine on the a frame AC TIEL: Total time oa tbe left engine (Also used to record single engine hours) AC TIER: Total time on the right engine. Table name Tabile name So in the tuigge, you need to increase all of them with value of CHAR HOURS FLOWN 4) (4 Points) Create trigger narned tEB_caa alapig that will automatically update the AC CUSTOMER table's CUS BALANCE before a ne CHARTER 1ow is added. Use the CHARTER table's CHAR TOT CHG as the update source (Assume that all charter charges ae charged to the custoae balan.) In addition to the CHAR_TOT CHG, add $25 for every quart of oil used on the charter ARCRAFT Answer the following questions based on the above database: 5) 4 Points) Create a stored procedure to update model charge per mile attrbute Procecure takes the model number as a parameter. The procedure increases the charge for this model by 25%. 1) (4 Points) Create a view named "ATL_CHARTERS_ that includes the following For each charter of aircraft to Atlanta (STL), print the charter date, charter hours flown, and the coresponding custouner last name, first name, area code, and phone number" Your answer should inchude both the SQL statement for view creating along with the contents of the view (von get the contents of the view by select from ATL-CHARTERS_). 6) (4 Points) Create a stored procedure that will take an Employee number and percentage, then update the corresponding employee's hourly salary by the input percentage increase the hourly salary, so you are giving the employee a raise). Hint: Ate Employee table to add the houri salafeld, pdate it with a value of 30 for all rowsin the table, bafore creating theprocedure. 2) (4 Points) Modify the MODEL table to add the following attribute: (Note: use ALTER TABLE and UPDATE coammands fox this