Database name: Cho3_AviaCo Table name: CHARTER CHARTRE CUR DATE CHUR PLOT CHUR COPE OTAC NUMBER CHUR DESTRATION CHURDISTANCE OUR HOURS LOWNOWAR HOURS VAITOHAR FUEL GALLONS CAROL OCUS Cool 10001 05-Feb-18 104 2282 AL 9380 51 22 1 3541 10011 10000 05-Feb-18 100 27787 BNA 320.0 16 00 726 0 10016 10000 05-Feb-1 105 109 4278Y ONY 15740 78 00 3898 2 10014 10000 06-Feb-18 100 16 SIL 472.0 29 4.9 972 1 10019 10005 05-Feb-18 S01 2207 ATL 10230 57 35 3977 2 10010 10008 05-Feb-18 100 4278Y STL 4720 26 52 117.1 0 10017 1000 06-Feb-18 104 105 2778 ON 15740 79 00 3484 2 10013 10000 07 Feb 18 30 100 145 TYS 6440 41 00 140.6 1 10014 10000 07-Feb-18 105 220L ONV 15740 66 234 4599 0 10017 10010 07 Feb-18 09 42787 ATL 9980 6 32 2797 0 10016 10011 OT-Feb-18 105 104 144P BNA 3520 19 5.3 564 1 1 1002 10012 08-Feb-10 101 2770 MOD 884.0 40 42 2151 0 10010 1001 08-Feb-18 105 4278 TYS 6440 39 45 1743 1 10011 1001 09-Feb-1e 100 4278Y ATL 836.0 5.1 2.1 3026 0 10017 10015 09.Feb 18 104 101 220 GNV 1645.0 67 00 459.5 2 2 10016 10016 10. 09.Feb 10 109 105 27707 MON 2120 15 00 672 0 100 10017 10-Feb-10 100 16P SIL 500.0 00 1055 O 10014 1001B 10.70-19 105 104 4278Y TYS 6440 38 45 1674 0 007 The destinations are indicated by standard three letter airport codes. For example, STL - St. Louis, MO ATL - Atlanta, GA BNA - Nashville, TN Table name: AIRCRAFT AC_NUMBER MOD_CODE AC TTAF ATTELAC TTER ACTTAF - Aircraft total time, airframe (hours) 1434P PA23.250 18331 18331 1018 AC_TTEL = Total time, left engine (hours) 22894 CHIA 4243.8 768 9 11234 AC TTER -Total time, right engine (hours) 27787 PA31.350 79929 1513.1 7895 4278Y PA31-350 21473 6221 2032 In a fully developed database system, such attribute values would be updated by application software when the CHARTER table entries are posted. Table name: MODEL MOO_CODE MOD_MANUFACTURER MOD_NAME MOD_SEATS MOO_CHG_MLE 8200 Beechcraft Super Kingar 10 193 C-90A Beechcraft Kangar 8 8 267 PA23-250 Piper Aztec 6 1.93 PA31-350 Piper Navajo Chieftain 10 2.35 Customers are charged per roundtrip mile, using the MOD_CHG_MILE rate. The MOD_SEATS gives the total number of seats in the airplane, including the pilot and copilot seats. Therefore, a PA31-350 trip that is flown by a pilot and a copilot has eight passenger seats available. 1 1 2 Table name: PILOT EMP NUM PIL LICENSE PIL RATINGS PL_MED_TYPE PL_MED_DATE PIL_PT135_DATE Database name: Ch03_AviaCo 101 ATP ATP/SELAMEL Anstr/CFII 20-Jan-18 11-Jan-18 104 ATP ATP/SELMELAnstr 18-Dec-17 17-Jan-18 105 COM COMMUSEL MELInstr/CFI 05-Jan-18 02-Jan-18 106 COM COMMISEL. MELInstr 2 10-Dec-17 02-Feb-18 109 COM ATPISELIMEL/SESInstr/CFI 1 22-Jan-18 15-Jan-18 The pilot licenses shown in the PILOT table include the ATP - Airline Transport Pilot and COM - Commercial Pilot. Businesses that operate "on demand" air services are governed by Part 135 of the Federal Air Regulations (FARs) that 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 each 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 2nd class medical certificate (PIL MED TYPE - 2.) The PIL_RATINGS include SEL - Single Engine, Land MEL - Multi-engine Land SES =Single Engine (Sea) Instr. = Instrument CFI = Certified Flight Instructor CFII = Certified Flight Instructor, Instrument Table name: EMPLOYEE EMP_NUM EMP_TITLE EMP_LNAME EMPFNAME EMP_NITIAL EMP_DOE EMP_HRE_DATE 100 M Kolmycz George D 15-Jun-62 15-Mar-08 101 Ms. Lewis Rhonda 19-Mar-85 25-Apr-06 102 M. Vandain Rhett 14-Nov-78 18-May-13 103 MS Jones Anne M 11-May-94 26-Jul-17 104 M Lange John P 12-Ju-91 20-Aug-10 105 M Wiliams Robert D 14-Mar-95 19-Jun-17 106 Mrs Duzak Jeanine K 12-Feb-88 13-Mar-18 107 Mr Diante Jorge D 01-May-95 02-Jul-16 108 M lesenbach Poul R 14-Feb-86 03-Jun-13 109 M Travis Eizabeth K 18-Jun-81 110 MS Leichis V 19-May-90 29-Jun-10 Table name: CUSTOMER CUS CODECUS LNAME CUS FNAME CUS INITIAL CUS AREACODECUS PHONE CUS BALANCE 10010 Ramas Alfred A 615 844-2573 0.00 10011 Dunne Leona K 713 894-1238 0.00 10012 Smith Kathy w 615 894.2285 896.54 10013 Olowski Paul F 615 894-2180 120519 10014 Orlando Myror 615 222-1672 673 21 10015 O Brian Amy B 713 442-3381 1014 56 10016 Brown James G 615 297 1228 0.00 10017 Williams George 615 290 2556 0.00 10018 Farriss Anne G 713 382-7185 000 10019 Smith Olotte K 615 297 3809 153.98 14-Feb-16 Genki 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 having a gross take-off weight over 12,500 pounds. None of the aircraft in the AIRCRAFT table are governed by this requirement; however, some customers may require the presence of a copilot for insurance reasons. All charter trips are recorded in the CHARTER table. 13. For each table, identify the primary key and foreign key(s) when possible. You want to see data on charters flown by either Robert Williams (employee number105) or Elizabeth Travis (employee number 109) as pilot or copilot, but not charters flown by both of them. Complete Problems 14-16 to find this information. 14. Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters flown by either employee 105 or employee 109. 15. Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters flown by both employee 105 and employee 109. 16. Create the table that would result from applying a DIFFERENCE relational operator of your result from Problem 14 to your result from Problem 15. Use the database shown in Figures 4 & 5 to answer Problems 1316. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of four aircraft. Aircrafts are identified by a unique registration number. Therefore, the aircraft registration number is an appropriate primary key for the AIRCRAFT table