DBs .StevenMorris 11e X file:///C:/Users/ADMIN/Documents/Downloads/DBs%20.Steven Morris%20-%2011e.pdf Fit to page Page view A) Read aloud Add notes of 786 EContents 139 P3.24 Database name: Ch03_AviaCo Table name: CHARTER CHAR_TRIP CHAR DATE CHAR PILOT CHAR_COPILOT AC NUMBER CHAR DESTINATION CHAR_DISTANCE CHAR HOURS FLOWN CHAR HOURS WAIT CHAR_FUEL_GALLONS CHAR_OIL_QTS CUS_CODE 354.1 10001 2289L 936.0 10011 05-Feb-14 104 ATL 5.1 2.2 1 05-Feb-14 10002 101 2778V BNA 320.0 1.6 0.0 72.6 0 10016 05-Feb-14 10003 105 109 4278Y GNV 1574.0 7.8 0.0 339.8 2 10014 06-Feb-14 1484P 10004 106 STL 472.0 2.9 4.9 97.2 1 10019 10005 1023.0 397.7 06-Feb-14 101 2289L ATL 5.7 3.5 2 10011 10006 4278Y 472.0 10017 06-Feb-14 109 STL 2.6 5.2 117.1 0 06-Feb-14 10007 104 105 2778V GNV 1574.0 7.9 0.0 348.4 2 10012 4.1 0,0 10008 07-Feb-14 106 1484P TYS 644.0 140.6 1 10014 10009 07-Feb-14 2289L 1574.0 6.6 105 GNV 23.4 459.9 0 10017 10010 07-Feb-14 109 ATL 998.0 6.2 3.2 279.7 10016 4278Y 0 07-Feb-14 10011 101 104 1484P BNA 352.0 1.9 5,3 66.4 08-Feb-14 10010 10012 101 2778V Мов 884.0 4.8 4.2 215.1 0 105 4278Y TYS 644.0 10013 08-Feb-14 3.9 4.5 174.3 1 10011 09-Feb-14 10014 ATL 10017 106 4278Y 936.0 6.1 2.1 302.6 0 10016 101 2289L 1645.0 6.7 459.5 10015 09-Feb-14 104 GNV 0.0 10016 09-Feb-14 1.5 109 105 2778V MQY 312.0 0,0 67.2 0 10011 10-Feb-14 10017 101 STL 508.0 3.1 0,0 105.5 0 1484P 10014 104 4278Y 10018 10-Feb-14 105 TYS 644.0 3.8 4.5 167.4 0 10017 The destinations are indicated by standard three-letter airport codes. For example, ATL Atlanta, GA STL St. Louis, MO BNA Nashville, TN Table name: AIRCRAFT AC-TTAF Aircraft total time, airframe (hours) AC-TTEL =Total time, left engine (hours) AC_TTER Total time, right engine (hours) AC_TTAF 1833.1 MOD_CODE PA23-250 AC TTEL AC_NUMBER AC TTER 1484P 1833.1 101.8 768.9 2289L C-90A 4243.8 1123.4 In a fully developed system, such attribute values would be updated by application software when the CHARTER table entries were posted. 789.5 243.2 РАЗ1-350 7992.9 1513.1 2778V РА31-350 2147.3 622.1 4278Y Table name: MODEL MOD_CODE MOD_MANUFACTURER MOD_SEATS MOD_CHG MILE MOD NAME C-90A KingAir Aztec 2.67 Beechcraft 8 Piper Piper PA23-250 6 1.93 2.35 РА31-350 Navajo Chieftain 10 16:14 PM Type here to search 21 03/11/2019 X DBs .StevenMorris 11e X file:///C:/Users/ADMIN/Documents/Downloads/DBs%20.Steven Morris% 20-%2011e.pdf Page view A) Read aloud Add notes Fit to width of 786 EContents 140 Table name: PILOT Database name: Ch03 AviaCo PIL MED TYPE PIL MED DATE PIL PT135 DATE EMP NUM PIL LICENSE PIL_RATINGS ATP/SELMELAnstr/CFII 101 ATP 1 20-Jan-14 11-Jan-14 104 ATP 18-Dec-13 17-Jan-14 ATP/SELMELAnstr 1 COMMISELMELAnstr/CFI 05-Jan-14 105 COM 02-Jan-14 02-Feb-14 COMMISELMELAnstr 10-Dec-13 106 COM 2 109 COM ATP/SELMELASESAnstr/CFll 1 22-Jan-14 15-Jan-14 The pilot licenses shown in the PILOT table include ATP = Airline Transport Pilot and COMM Commercial Pilot. Businesses that operate on-demand air services are governed by Part 135 of the Federal Air Regulations (FARS), which are enforced by the Federal Aviation Administration (FAA). Such businesses are known as "Part 135 operators." Part 135 operations require that pilots successfully complete flight proficiency checks every six months. The "Part 135" flight proficiency check date is recorded in PIL_PT135_DATE. To fly commercially, pilots must have at least a commercial license and a second-class medical certificate (PIL_MED_TYPE = 2) The PIL RATINGS include: SEL Single Engine, Land SES = Single Engine, Sea CFI Certified Flight Instructor MEL Multiengine, Land Instr. = Instrument CFII Certified Flight Instructor, Instrument Table name: EMPLOYEE EMP NUM EMP_TITLE | EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB EMP_HIRE_DATE 15-Mar-88 25-Apr-86 18-May-93 26-Jul-99 20-Aug-90 15 Jun-42 19-Mar-65 14-Nov 58 Kolmycz Lewis Vandam Jones Lange Williams Duzak Diante Wiesenbach 100 Mr George Rhonda 101 Ms. 102 Mr 103 Ms G Rhett M Anne 11-May-74 12-Jul-71 104 Mr John P 14-Mar-75 12-Feb-68 01-May-75 14-Feb-66 18-Jun-61 19-May-70 19-Jun-03 13-Mar-89 02-Jul-97 105 Mr 106 Mrs 107 Mr Robert Jeanine Jorge Paul 03-Jun-93 14-Feb-06 108 Mr Elizabeth Leighla 109 Ms Travis K Genkazi 29-Jun-90 110 Mrs. Table name: CUSTOMER CUS CODE CUS FNAME Alfred CUS AREACODE CUS PHONE CUS BALANCE 0.00 0.00 896 54 1285,19 673.21 1014.56 CUS LNAME CUS INITIAL 10010 Ramas 10011 Dunne 10012 Smith 10013 Olowski 10014 Orlando 844-2573 615 A K 894-1230 894-2285 894-2180 222-1672 Leona 713 Kathy Paul W 615 F 615 615 Myron Amy James в G 10015 O'Brian 713 442-3381 297-1228 290-2556 10016 Brown 615 0.00 10017 Williams George 615 0.00 0.,00 453 98 382-7185 297-3809 713 10018 Farriss G Anne 10019 Smith Olette K 615 Cengage Leaming O 2015 The nulls in the CHARTER table's CHAR_COPILOT column indicate that a copilot is not required for some charter trips or for some aircraft. Federal Aviation Administration (FAA) rules require a copilot on jet aircraft and on aircraft 16:15 PM Type here to search 21 03/11/2019 X