Question: Database name: Ch03_AviaCo 141 Table name: CHARTER OUR TOUR DATOS OU COLOAG NUMERO DESTRATION OW GIANCE OUR HOURS LOW HOURS WAT OUR FEL GALLONOWE Cuscoce

Database name: Ch03_AviaCo 141 Table name:
Database name: Ch03_AviaCo 141 Table name:
Database name: Ch03_AviaCo 141 Table name:
Database name: Ch03_AviaCo 141 Table name: CHARTER OUR TOUR DATOS OU COLOAG NUMERO DESTRATION OW GIANCE OUR HOURS LOW HOURS WAT OUR FEL GALLONOWE Cuscoce 10001 05.10 104 2207 ATL 1000) 05.10 90 101 27V NA SI 22 10011 10003 05-Feb 10 104 1000 3200 18 00 ON 10004 720 06. Feb 18 15140 106 10016 1464 70 STIL 00 330 4720 2 1000 10014 101 2200 ATL 29 49 972 1 1000 10010 06.18 10230 100 4278 $? ST 35 77 2 10007 6720 06-Feb-10 10011 104 26 106 2720 ON 52 1171 15140 o 10000 1001? 017-18 106 1404P tys 19 00 04 2 1000 5440 10012 07710 105 22016 41 GNV 00 1406 15740 + 10010 10014 07-F.-10 66 42TOV 100 234 4999 980 AR 0 10011 10017 077-18 100 62 104 144P SNA 32 2193 0015 10012 09-76-18 3520 19 53 101 277 MOO 384 1 10013 3040 10012 07.18 46 105 4270 47 TYS 2151 5400 0 10014 On Feb. 106 427 39 65 1743 ATL 1 9380 10011 10015 09-10 104 61 2.1 101 2206 GNV 3026 16450 10017 10016 67 07-10 100 00 104 27787 4995 MOV 3120 2 10017 15 0016 10-Feb-1 101 1450 00 STL 5000 62 0 1001 1001 31 10-Feb-10 105 00 104 TV TYS 1055 . 10014 5440 3 1674 0 TOOL The destinations are indicated by standard three letter airport codes. For example, STL - St. Louis, MO ATL-Atlanta, GA BNA - Nashville, TN 10010 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. Database name: Ch03_AviaCo 10006 Table name: CHARTER CHARTER CHIAR DATE OUR LOT OARECOPLOTAC NUMBER CUR DESTINATION CHARDSTANCE CHUR HOURS FLOW OUR HOURS WATOW FUEL GALLONSCHAR OL GISCUS CODE 10001 05-Feb-1 104 ATL 8980 5.1 22 3541 1 10011 10000 10 101 2778 ENA 2200 16 00 726 0 1001 10000 05-Feb-10 105 103 4TBY GNV 15740 70 00 3390 2 10014 10004 DE 10 100 1434 STL 4720 29 49 072 10019 TOS 05-Feb-18 100 2200 AL 10230 57 35 97 2 10011 05-750 100 42787 STL 4720 28 1171 0 10017 10007 06.10 104 105 27707 ONV 1540 79 00 3484 2 10012 10000 01 Feb 10 100 TVS 5440 00 1406 1 10014 OF10 105 220 ON 15740 234 4 0 10017 SOLO OF 7-16 100 TV ATL WD 62 32 0 10010 10011 Oth 100 104 1464 NA 320 13 53 064 + 10012 10013 07.10 100 27787 MOO 3640 40 42 2150 0 10010 10013 071 106 4TV TV 6440 29 45 1943 1 10011 100 07-10 100 4270 ATE 9000 61 20 2006 10015 0.71 104 101 2202 ONY 16450 00 2 100 10016 t| 100 105 27 MOV 3120 15 00 672 10000 10017 100 101 160 S80 31 00 10018 10014 10. Feb 18 105 104 cm TYS 6440 38 45 100 10000 10017 1055 The destinations are indicated by standard three letter airport codes. For example, STL - St. Louis, MO ATL - Atlanta, GA BNA - Nashville, TN

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!