5) 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%.

6) 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.

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