Table name: CHARTER CHAR TRIPCHAR DATE AC NUMBER CHAR_DESTRATION CHAR_DISTANCE CHAR_HOURS_FLOWN CHAR_HOURS WAIT] CHAR FUEL GALLONS...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Table name: CHARTER CHAR TRIPCHAR DATE AC NUMBER CHAR_DESTRATION CHAR_DISTANCE CHAR_HOURS_FLOWN CHAR_HOURS WAIT] CHAR FUEL GALLONS CHAR_OL_015 CUS.CODE 10001 05-Feb-18 229 10000 05-Feb-10 2778 10000 05-Feb-18 4278Y 10004 05-Feb-18 1434 10006 05-F6-18 220 10006 05./eb-10 4278Y 10007 05-Feb-10-277BV 10000 07-Feb-18 1414P 10009 07-Fat-18 220 10040 07-Feb-10 427BY 10019 07-Feb-10 143-P 10012 05-Feb-18 2778 10013 08-76-18 427RY 10014 09-Feb-10 427WY 10015 07-FM-18 2238 10016 03-Fet-10 2778 10017 10.Feb-18 1404P 10010 10-Feb-18 42NY 10003 10003 229 2778V 4378Y 10004 10005 10006 10007 10007 10008 10009 10096 10011 10011 10012 10013 10014 10015 10015 10016 Table name: CREW OHAR TRUPINP JUM CROW JOB 10001 104 Phot 10002 101 PROS 605 Plat 608 Copket SON PAY 101 PRE 108 Pd 104 Pkt 105 Coplut 105 Pkt 10016 10017 10018 10018 105 PR 108 PROY 101 P 804 Copket 101 PA 105 PAY 106 Pad 101 Confit ATL 104 PA 605 Copet 109 PRE 101 PAT 104 Caplet 105 Pkt ONV STL ATL STL ONV TVS GNV ATL INA MOB TVS ATL ONV MOY STL TYS Table name: AIRCRAFT AC NUMBER MOO 000E AC TTAF 1833.1 PA23-250 C-904 4243.8 PA31-350 79329 PA31-350 18010 Fames 18001 Dunne 18062 Smith 10013 Ok 10014 Ons 18005 Ofrien 18005 Brown 10017 18000 Fariss 10099 Smth 100 M 101 M 102 Mr 103 Mr. 104 105 Mr. 100 Mrs. 107 M 103 Mr. 109 M 110 Mrs. 236 330 1574 472 AG TTIL AC THER 10331 101 A 709.9 472 1574 644 1574 916 11254 709:5 312 1804 644 9036 312 510 644 Katty Faul Myan Amy Janes George Arre Olette Table name: CUSTOMER CUS_CODE CUS_LINAME CUS PNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE Aftred Loose Vandam Jorms Lange villons Cursk Cherte etecentach F Oerked D 9 Q hands That Arre 5.1 16 78 Robert 57 26 75 41 66 82 19 40 39 61 15 Jorge Pou Eizabeth 105.COM 100 COM 109 COM 713 605 ens 605 713 605 685 783 EMP NLM PL LICENSE 101 ATP 104 ATP 0 G 164 D K Table name: PILOT O 0 Table name: EMPLOYEE MP-NUM DOSTLE DE UNAME OF NAME OF NTAL OF DC (MPHRE DATE Molnyc 15-in-1942 19-Mar-1995 14-Nov-1958 16-Ord-1974 08-Nov-1971 14-at-1975 12-Feb-1958 D R K 49 35 62 0 O 32 42 45 21 O O O 944-2573 094-1238 054-2100 443.3001 287-1220 362-7105 297-3009 3541 726 2398 972 21-Aug-1974 14-Feb-1968 15-Jun-1961 15-May-1978 117.8 3404 1408 4599 664 215.1 1743 ATPISELAELSESINOFF 1 1955 DOO 0.00 096.54 1205.19 673.21 1014.56 0:00 DOO 0:00 15-Mar-1967 25-Apr-1989 23-Dec-1992 28-Aug-2005 20-0dd-1105 05-JM-2000 03-A4-1995 15-NOW-1998 14-Apr-1991 01-Dec-1902 CFI CFI 1 D HEL SEL SES 1 2 . 2 1 D . 1 D 1 D 2 D D 10006 10014 10011 10017 10082 18-Dec-17 10014 10087 10000 10012 10000 10011 10087 10-Dec-17 10001 10064 10017 Table name: RATING 10.000 R10 NAME Certified Fight Instructor Costed Fight Instructor, trunert Instrument Mengine Land Database name: Ch08_AviaCo Table name: EARNEDRATING EMP NUM RTO CODE BARRTO CATE 18-Feb-90 101 CF 101 CPM 15-040-05 101 INSTR 101 MEL 101 SEL 104 INSTR 06-Nov-93 23-an-94 21-Apr-83 15-34-90 10 MEL 104 18 105 CF 105 INSTR 105 MEL 105 SEL 105 INSTR 100 MEL PL MED TYPE PL MED DATE PL PT135 DATE 1 11-Jan-16 PL RATINGS ATP/SELMELIOF ATSELMEL 1 OOMISELMELCF 2 COMSELMEL 17-Jan-18 02-Jan-10 00-Feb-10 15-JM-18 Single Engine, Land Single Engine, See 105 SEL 109 cr 109 CFM 108 INSTR Table name: MODEL MOD CODE MOD MANUFACTURER MOD NAME C-804 Deechcraft KingAr PA25-25 per Artic PA31-300 per Navjo Chieftain 109 MEL 109 SEL 109 SES 12-Mar-95 15-Nov-Gr 17-Apr-95 12-Aug-95 25-5ep-94 20-046-95 02-Apr-90 10-Mar-04 15-Nov-93 21-an-03 23-14-90 15-MM-07 12-Mex-90 MOD SEATS MOD CHO MLE 267 193 231 Table name: CHARTER CHAR TRIPCHAR DATE AC NUMBER CHAR_DESTRATION CHAR_DISTANCE CHAR_HOURS_FLOWN CHAR_HOURS WAIT] CHAR FUEL GALLONS CHAR_OL_015 CUS.CODE 10001 05-Feb-18 229 10000 05-Feb-10 2778 10000 05-Feb-18 4278Y 10004 05-Feb-18 1434 10006 05-F6-18 220 10006 05./eb-10 4278Y 10007 05-Feb-10-277BV 10000 07-Feb-18 1414P 10009 07-Fat-18 220 10040 07-Feb-10 427BY 10019 07-Feb-10 143-P 10012 05-Feb-18 2778 10013 08-76-18 427RY 10014 09-Feb-10 427WY 10015 07-FM-18 2238 10016 03-Fet-10 2778 10017 10.Feb-18 1404P 10010 10-Feb-18 42NY 10003 10003 229 2778V 4378Y 10004 10005 10006 10007 10007 10008 10009 10096 10011 10011 10012 10013 10014 10015 10015 10016 Table name: CREW OHAR TRUPINP JUM CROW JOB 10001 104 Phot 10002 101 PROS 605 Plat 608 Copket SON PAY 101 PRE 108 Pd 104 Pkt 105 Coplut 105 Pkt 10016 10017 10018 10018 105 PR 108 PROY 101 P 804 Copket 101 PA 105 PAY 106 Pad 101 Confit ATL 104 PA 605 Copet 109 PRE 101 PAT 104 Caplet 105 Pkt ONV STL ATL STL ONV TVS GNV ATL INA MOB TVS ATL ONV MOY STL TYS Table name: AIRCRAFT AC NUMBER MOO 000E AC TTAF 1833.1 PA23-250 C-904 4243.8 PA31-350 79329 PA31-350 18010 Fames 18001 Dunne 18062 Smith 10013 Ok 10014 Ons 18005 Ofrien 18005 Brown 10017 18000 Fariss 10099 Smth 100 M 101 M 102 Mr 103 Mr. 104 105 Mr. 100 Mrs. 107 M 103 Mr. 109 M 110 Mrs. 236 330 1574 472 AG TTIL AC THER 10331 101 A 709.9 472 1574 644 1574 916 11254 709:5 312 1804 644 9036 312 510 644 Katty Faul Myan Amy Janes George Arre Olette Table name: CUSTOMER CUS_CODE CUS_LINAME CUS PNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE Aftred Loose Vandam Jorms Lange villons Cursk Cherte etecentach F Oerked D 9 Q hands That Arre 5.1 16 78 Robert 57 26 75 41 66 82 19 40 39 61 15 Jorge Pou Eizabeth 105.COM 100 COM 109 COM 713 605 ens 605 713 605 685 783 EMP NLM PL LICENSE 101 ATP 104 ATP 0 G 164 D K Table name: PILOT O 0 Table name: EMPLOYEE MP-NUM DOSTLE DE UNAME OF NAME OF NTAL OF DC (MPHRE DATE Molnyc 15-in-1942 19-Mar-1995 14-Nov-1958 16-Ord-1974 08-Nov-1971 14-at-1975 12-Feb-1958 D R K 49 35 62 0 O 32 42 45 21 O O O 944-2573 094-1238 054-2100 443.3001 287-1220 362-7105 297-3009 3541 726 2398 972 21-Aug-1974 14-Feb-1968 15-Jun-1961 15-May-1978 117.8 3404 1408 4599 664 215.1 1743 ATPISELAELSESINOFF 1 1955 DOO 0.00 096.54 1205.19 673.21 1014.56 0:00 DOO 0:00 15-Mar-1967 25-Apr-1989 23-Dec-1992 28-Aug-2005 20-0dd-1105 05-JM-2000 03-A4-1995 15-NOW-1998 14-Apr-1991 01-Dec-1902 CFI CFI 1 D HEL SEL SES 1 2 . 2 1 D . 1 D 1 D 2 D D 10006 10014 10011 10017 10082 18-Dec-17 10014 10087 10000 10012 10000 10011 10087 10-Dec-17 10001 10064 10017 Table name: RATING 10.000 R10 NAME Certified Fight Instructor Costed Fight Instructor, trunert Instrument Mengine Land Database name: Ch08_AviaCo Table name: EARNEDRATING EMP NUM RTO CODE BARRTO CATE 18-Feb-90 101 CF 101 CPM 15-040-05 101 INSTR 101 MEL 101 SEL 104 INSTR 06-Nov-93 23-an-94 21-Apr-83 15-34-90 10 MEL 104 18 105 CF 105 INSTR 105 MEL 105 SEL 105 INSTR 100 MEL PL MED TYPE PL MED DATE PL PT135 DATE 1 11-Jan-16 PL RATINGS ATP/SELMELIOF ATSELMEL 1 OOMISELMELCF 2 COMSELMEL 17-Jan-18 02-Jan-10 00-Feb-10 15-JM-18 Single Engine, Land Single Engine, See 105 SEL 109 cr 109 CFM 108 INSTR Table name: MODEL MOD CODE MOD MANUFACTURER MOD NAME C-804 Deechcraft KingAr PA25-25 per Artic PA31-300 per Navjo Chieftain 109 MEL 109 SEL 109 SES 12-Mar-95 15-Nov-Gr 17-Apr-95 12-Aug-95 25-5ep-94 20-046-95 02-Apr-90 10-Mar-04 15-Nov-93 21-an-03 23-14-90 15-MM-07 12-Mex-90 MOD SEATS MOD CHO MLE 267 193 231 Table name: CHARTER CHAR TRIPCHAR DATE AC NUMBER CHAR_DESTRATION CHAR_DISTANCE CHAR_HOURS_FLOWN CHAR_HOURS WAIT] CHAR FUEL GALLONS CHAR_OL_015 CUS.CODE 10001 05-Feb-18 229 10000 05-Feb-10 2778 10000 05-Feb-18 4278Y 10004 05-Feb-18 1434 10006 05-F6-18 220 10006 05./eb-10 4278Y 10007 05-Feb-10-277BV 10000 07-Feb-18 1414P 10009 07-Fat-18 220 10040 07-Feb-10 427BY 10019 07-Feb-10 143-P 10012 05-Feb-18 2778 10013 08-76-18 427RY 10014 09-Feb-10 427WY 10015 07-FM-18 2238 10016 03-Fet-10 2778 10017 10.Feb-18 1404P 10010 10-Feb-18 42NY 10003 10003 229 2778V 4378Y 10004 10005 10006 10007 10007 10008 10009 10096 10011 10011 10012 10013 10014 10015 10015 10016 Table name: CREW OHAR TRUPINP JUM CROW JOB 10001 104 Phot 10002 101 PROS 605 Plat 608 Copket SON PAY 101 PRE 108 Pd 104 Pkt 105 Coplut 105 Pkt 10016 10017 10018 10018 105 PR 108 PROY 101 P 804 Copket 101 PA 105 PAY 106 Pad 101 Confit ATL 104 PA 605 Copet 109 PRE 101 PAT 104 Caplet 105 Pkt ONV STL ATL STL ONV TVS GNV ATL INA MOB TVS ATL ONV MOY STL TYS Table name: AIRCRAFT AC NUMBER MOO 000E AC TTAF 1833.1 PA23-250 C-904 4243.8 PA31-350 79329 PA31-350 18010 Fames 18001 Dunne 18062 Smith 10013 Ok 10014 Ons 18005 Ofrien 18005 Brown 10017 18000 Fariss 10099 Smth 100 M 101 M 102 Mr 103 Mr. 104 105 Mr. 100 Mrs. 107 M 103 Mr. 109 M 110 Mrs. 236 330 1574 472 AG TTIL AC THER 10331 101 A 709.9 472 1574 644 1574 916 11254 709:5 312 1804 644 9036 312 510 644 Katty Faul Myan Amy Janes George Arre Olette Table name: CUSTOMER CUS_CODE CUS_LINAME CUS PNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE Aftred Loose Vandam Jorms Lange villons Cursk Cherte etecentach F Oerked D 9 Q hands That Arre 5.1 16 78 Robert 57 26 75 41 66 82 19 40 39 61 15 Jorge Pou Eizabeth 105.COM 100 COM 109 COM 713 605 ens 605 713 605 685 783 EMP NLM PL LICENSE 101 ATP 104 ATP 0 G 164 D K Table name: PILOT O 0 Table name: EMPLOYEE MP-NUM DOSTLE DE UNAME OF NAME OF NTAL OF DC (MPHRE DATE Molnyc 15-in-1942 19-Mar-1995 14-Nov-1958 16-Ord-1974 08-Nov-1971 14-at-1975 12-Feb-1958 D R K 49 35 62 0 O 32 42 45 21 O O O 944-2573 094-1238 054-2100 443.3001 287-1220 362-7105 297-3009 3541 726 2398 972 21-Aug-1974 14-Feb-1968 15-Jun-1961 15-May-1978 117.8 3404 1408 4599 664 215.1 1743 ATPISELAELSESINOFF 1 1955 DOO 0.00 096.54 1205.19 673.21 1014.56 0:00 DOO 0:00 15-Mar-1967 25-Apr-1989 23-Dec-1992 28-Aug-2005 20-0dd-1105 05-JM-2000 03-A4-1995 15-NOW-1998 14-Apr-1991 01-Dec-1902 CFI CFI 1 D HEL SEL SES 1 2 . 2 1 D . 1 D 1 D 2 D D 10006 10014 10011 10017 10082 18-Dec-17 10014 10087 10000 10012 10000 10011 10087 10-Dec-17 10001 10064 10017 Table name: RATING 10.000 R10 NAME Certified Fight Instructor Costed Fight Instructor, trunert Instrument Mengine Land Database name: Ch08_AviaCo Table name: EARNEDRATING EMP NUM RTO CODE BARRTO CATE 18-Feb-90 101 CF 101 CPM 15-040-05 101 INSTR 101 MEL 101 SEL 104 INSTR 06-Nov-93 23-an-94 21-Apr-83 15-34-90 10 MEL 104 18 105 CF 105 INSTR 105 MEL 105 SEL 105 INSTR 100 MEL PL MED TYPE PL MED DATE PL PT135 DATE 1 11-Jan-16 PL RATINGS ATP/SELMELIOF ATSELMEL 1 OOMISELMELCF 2 COMSELMEL 17-Jan-18 02-Jan-10 00-Feb-10 15-JM-18 Single Engine, Land Single Engine, See 105 SEL 109 cr 109 CFM 108 INSTR Table name: MODEL MOD CODE MOD MANUFACTURER MOD NAME C-804 Deechcraft KingAr PA25-25 per Artic PA31-300 per Navjo Chieftain 109 MEL 109 SEL 109 SES 12-Mar-95 15-Nov-Gr 17-Apr-95 12-Aug-95 25-5ep-94 20-046-95 02-Apr-90 10-Mar-04 15-Nov-93 21-an-03 23-14-90 15-MM-07 12-Mex-90 MOD SEATS MOD CHO MLE 267 193 231
Expert Answer:
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these databases questions
-
Can you elaborate on the neurobiological foundations of emotional intelligence, examining the interplay between cognitive processes, emotional regulation, and social cognition in shaping individual...
-
Create the ERD. Use the database shown in Figure P3.24 to answer this Problem. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of four aircraft....
-
Instructions: Read the footnotes included in the financial statements for H & B Bakery, then answer the following questions. *The exact requirement of this question, is to read the statements below...
-
The stockholders' equity of Thomas Company as of December 31, 2014, was as follows: Common stock, $1 par, authorized 275,000 shares; 240,000 shares issued and outstanding . . . . . . . . . . . . . ....
-
Given that a transaction is a financial event that requires changing the statement of financial position, decide whether or not each of the following (on this page and the next) is a transaction. You...
-
Great Wall Chinese Cuisine had \($93,000\) of total assets and \($31,000\) of total stock holders equity at May 31,2010. At May 31, 2011, Great Wall Chinese Cuisine had assets totaling \($147,000\)...
-
The following table contains a partial list of countries, the continents on which they are located, and their respective gross domestic products (GDP) in U.S. dollars. A list of 125 countries and...
-
A farmer collects 2 containers of milk and sells them to an ice cream manufacturer for $20 each. The ice cream manufacturer creates 10 tubs of chocolate ice cream which it sells to a grocery store...
-
The Norman Company recently adopted an incentive plan. Factory workers are paid P7.50 per unit with a guaranteed minimum wage of P2,000 per week. Following is a report on employees' productivity for...
-
Solve 23z + 19 = 3(5z - 9) + 8z + 46.
-
1. a) State the restrictions (domain) for log3(x+5)=2-log, (x-3)
-
Determine if the given system is consistent. Do not completely solve the system. - 6x4 = -14 2X1 2x2 +23 = 0 X3 +6x4 = 0 - 5x1 +3X2 +5X3 + x4 = 60 9
-
Referring to Exhibit 3.3 from scenario, then answer the following questions. Phase 1 Identify and diagnose the problem Phase 2 Generate alternative solutions , and using the statistics knowledge...
-
How many grams of salt are needed to make 657 g of salt water that is 38.0% salt by mass?
-
Which of the following isa correct use of cross-validation? a. Selecting variables to include in a model b. Comparing predictors c. Selecting parameters in the prediction function d. All of the...
-
A consultant is beginning work on three projects. The expected profits from these projects are $50,000, $72,000, and $40,000. The associated standard deviations are $10,000, $12,000, and $9,000....
-
What is the difference between the COUNT aggregate function and the SUM aggregate function?
-
Discuss the importance and characteristics of database data backup and recovery procedures. Then describe the actions that must be detailed in backup and recovery plans.
-
Bsed on the following query: SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX FROM EMPLOYEE WHERE EMP_SEX = F AND EMP_AREACODE = 615 ORDER BY EMP_LNAME, EMP_FNAME; What is the likely data sparsity...
-
Imagine you are a decision-maker about to allocate millions of dollars to-ward an SoS. The analysts have told you that the SoS configuration they recommend was developed using an agent-based model....
-
Choose one of the items below to complete: a. Prepare an abstraction depiction /paper model and complete pseudo-code that would implement a fire escape ABM for a university class-room. Pseudo-code...
-
Discuss THREE possible reasons why an entitys gross profit margin might increase from one year to the next.
Study smarter with the SolutionInn App