Question: Start SQL*Plus, Write and execute SQL for the following queries. Save each successful commands in file. Note that the commands use the following tables: Airport(Airport,

Start SQL*Plus, Write and execute SQL for the following queries. Save each successful commands in file. Note that the commands use the following tables:

Airport(Airport, AName, CheckIN, Resvtns, FlightInfo)

Route(RouteNo, RDescription)

Fares(FareType, Fdescription, Conditions)

Tariff(RouteNo , FareType, Price)

Aircraft(AircraftType, ADescription, NoSeats)

Flight(FlightNo, FromAirport, ToAirport, DepTime, ArrTime, Service, AircraftType, RouteNo)

Passenger(Pid, Name, Address, TelNo)

Ticket(TicketNo, TicketDate, PID)

Itinerary(TicketNo, FlightNo, LegNo, FlightDate, FareType)

q1?List the code of those airports that do not have any flights with scheduled departure time between 1:00 am (0100) and 7:30am (0730).

q2?List the names of the passengers with at least two tickets which cost over 180 each.

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.Start SQL*Plus 2.Write and execute SQL for the following queries. Save each successful commands in file. Note that the commands use the following tables: Airport(Airport, AName, CheckIN, Resvtns,...

Create a SQL script containing your data definition language (DDL) statements to create your tables, views, triggers, and other required database objects for your project. Your script must also...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Create a SQL script containing your data definition language (DDL) statements to create your tables, views, triggers, and other required database objects for your project. Your script must also...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Statement purpose To understand how to insert new rows into a table make them permanently stored (COMMIT statement). To Drop a table, run a script file (using the START sql*plus command) and check...

I need this in SQL, please Statement purpose To understand how to insert new rows into a table make them permanently stored (COMMIT statement). To Drop a table, run a script file (using the START...

To understand how to insert new rows into a table make them permanently stored (COMMIT statement). To Drop a table, run a script file (using the START sql"plus command) and check table content using...

INSERT INTO It is used to add one or more rows to a table Attribute values should be listed in the same order as the attributes were specified in the CREATE TABLE command INSERT INTO tablename...

Shown here are the consumer price indexes (CPIs) for housing for the years 1988 through 2005 from the Bureau of Labor Statistics Data Web site. Use the data to answer the following questions. a....

Convert the following units to those indicated: a) 143460 mm2 b) 1.23 Mg c) 5.60 t d) 45k m/h e) 14.8 cm f) 1.256 m3 g) 0.042 MJ h) 23.64 kN/m i) 23.64 kNm m2 kg kg m/s (write your answer in...

What are the two key benefits to a firm of going public? Increased ability to raise capital Decreased ownership liquidity Decreased regulation Increased ability for shareholders to diversify

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Discuss three reasons why recruiting is important to organizational success.

Evaluate the importance of diversity in the workforce.

Identify the legal standards of the recruitment process.