Question: Database name: Ch08 AviaCo Table name: CHARTER CHAR TRIP CHAR DATE AC NUMBER CHAR DESTINATION CHAR DISTANCE CHAR HOURS FLOWN CHAR HOURS WAIT CHAR FUEL

Database name: Ch08 AviaCo Table name: CHARTER CHAR TRIP CHAR DATE

AC NUMBER CHAR DESTINATION CHAR DISTANCE CHAR HOURS FLOWN CHAR HOURS WAIT

Database name: Ch08 AviaCo Table name: CHARTER CHAR TRIP CHAR DATE AC NUMBER CHAR DESTINATION CHAR DISTANCE CHAR HOURS FLOWN CHAR HOURS WAIT CHAR FUEL GALLONS CHAR OIL OTS CUS CODE 10011 Table name: EARNEDRATINOG 10001 05-Feb-08 2289L 10002 05-Feb-08 2778V 10003 05-Feb-08 4278Y 1000406-Feb-08 1484P 10005 06-Feb-08 2289L 10006 06-Feb-08 4278Y 10007 06-Feb-08 2778V 10008 07-Feb-08 1484P 000907-Feb-08 2289L 10010 07-Feb-08 4278Y 10011 07-Feb-08 1484P 10012 08-Feb-08 2778V 10013 08-Feb-08 4278 ENA 10016 EMP NUM RTG CODE EARNRTG DATE 10014 10019 18-Feb-98 1574 644 1574 10017 10012 10014 10017 10016 21-Apr-93 15-Jul-96 TYS 140.6 104 INSTR 18-Nov-97 17-Apr-95 TYS 644 936 1645 10017 10016 09-Feb-08 4278Y 106STR 10015 09-Feb-08 2289L 10016 09-Feb-08 2778V 10017 10-Feb-08 1484P 10018 10-Feb-08 4278Y 105.5 10-Mar-94 10014 10017 TYS Table name: CREW Table name: CUSTOMER 15-Mar-97 05-Feb-96 CHAR TRIP EMP NUM CREW JOBCUS CODE CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE 10010 Ramas 10011 Dunne 10012 Smith 0013 Olowski 10014 Orlando 10015 Brian 10016 Brown 10017 iliams 10018 Farriss 10019 Smith 894-1238 1285.19 Table name: RATING RTG NAME 894-2180 Myron 1014.56 CF Certified Flight Instructor Certified Flight Instructor, Instrument 10007 Copilot 382-7185 809 Single Engine, Land Single Engine, Sea Table name: EMPLOYEE 10011 104 Copilot EMP NUM EMP TITLE EMP LNAME EMP FNAME EMP INTIAL EMP D0 EMP HIRE DATE 10012 10013 10014 100 Mr 15-Jun-1942 15-Mar-1987 19-Mar-1965 25-Apr-1988 Table name: MODEL 14-Nov-1958 102 Mr 20-Dec-1992 MOD CODE MOD MANUFACTURER MOD MOD SEATS MOD CHG Copilot 16-Oct-1974 28-Aug-2005Aeechcraf 2.67 105 Mr 106 Mrs 20-Oct-1996 PA23-250 Piper 08-Jan-2006 PA31-350 Piper Navajo Chieftain 12-Feb-196805-Jan-1991 21-Aug-1974 02-J1.1 996 14-Feb-1966 18-Jun-1961 19-May-1970 01-Dec-1992 Duzak 10017 10018 10018 104 Copilot 108 Mr 18-Nov-1994 Table name: AIRCRAFT Table name: PILOT AC NUMBER MOD CODE AC TTAF AC TTEL AC TTER EMP NUM PIL LICENSE PIL RATINGS PIL MED_TYPE PIL MED DATE PIL PT135 DATE PA23-250 ATPISELMELAnstriCFI ATPISELMELAnstr COMMISELMELAnstr CF 2 4243.8 PA31-350 PA31-350 1513.1 21473 02-Feb-08 ATPISELMELISESAnstrICFI

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 Databases Questions!

1. Create a trigger named trg_char_hours that will automatically update the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER tables CHAR_HOURS_FLOWN to update the AIRCRAFT tables...

Database Management Systems Triggers and Stored Procedures Answer the following questions based on the above database: 1) Create a view named ATL_CHARTERS_V that includes the following For each...

Database Management Systems Question 1: Normalization Consider a relation R with six attributes ABCDEF where AB is a composite primary key for R. Assume R has the following functional dependencies (R...

(4 Points) Modify the MODEL table to add the following attribute: (Note: use ALTER TABLE and UPDATE commands for this question.) Once the attribute has been added, update the values of all rows as...

NEED HELP WITH 4, 5, AND 6. ALSO I HAVE PROVIDED SQL COMMAND IN THE END FOR THE DATA. create database assignment5; use assignment5; CREATE TABLE AIRCRAFT ( AC_NUMBER varchar(5) primary key, MOD_CODE...

Database help bas on this table. thanks Answer the following questions based on the above database: 1.Create a view named ATL_CHARTERS_V that includes the following For each charter of aircraft to...

Answer the following questions based on the above database: (4 Points) Create a view named ATL_CHARTERS_V that includes the following For each charter of aircraft to Atlanta (ATL), print the charter...

3.) Create a trigger named trg_char_hours that will automatically update the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER tables CHAR_HOURS_FLOWN to update the AIRCRAFT tables...

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

What kind of people served on the IASC when it was initially established?

A block of ice dropped into a tank of water as shown (see accompanying animation) begins melting. Identify the interactions for the (a) Ice as a system. (b) Water in the tank as a system. (c) Water...

Graded Homework ( i ) December 3 1 , 2 0 2 3 , Berclair Incorporated had 3 0 0 million shares of common stock and 8 million shares of 9 8 , 5 1 0 0 par value mulative preferred stock issued and...

Present and future values of $1 at 11% are presented below. On October 1, 2024, Justine Company purchased equipment from Napa Incorporated in exchange for a noninterest-bearing note payable in slx...

2. What recommendations will you make to the city council?

4. What methods would you find most useful in trying to deal with the conflict?

3. The group answers the questions.