Question: Write an Oracle bgunix ProC program to query the tables (see below). The tables may be accessed as RayKresman. TableName where TableName is Aircraft or

 Write an Oracle bgunix ProC program to query the tables (see

Write an Oracle bgunix ProC program to query the tables (see below). The tables may be accessed as RayKresman. TableName where TableName is Aircraft or Flights. Aircraft (airplanelD number(2) primary key, airplaneName char(20), cruisingRange numberS): Flights (airplanelD number (2), flightNo number(4) primary key fromAirport char(20), toAirport char(20), distance number(4), depart timestamp, arrives timestamp, foreign key (airplaneID) references Aircraft); Queries: ane 2. Print for each flight (whose duration is between 1 hour 15 minutes to 3 hours and 15 minutes-both inclusive): flightNo, fromAirport, toAirport, flightDuration. Query 1 if an airplanelD has no flight, no need to print its info Query 2 - do not worry about time zones. Limit width of flightDuration to 20 columns. Google oracle timestamp functions to work with timestamps (for example, https://stackoverflow.com/questions/257324/oracle-how-t o-add-minutes-to-a-timestamp) Write an Oracle bgunix ProC program to query the tables (see below). The tables may be accessed as RayKresman. TableName where TableName is Aircraft or Flights. Aircraft (airplanelD number(2) primary key, airplaneName char(20), cruisingRange numberS): Flights (airplanelD number (2), flightNo number(4) primary key fromAirport char(20), toAirport char(20), distance number(4), depart timestamp, arrives timestamp, foreign key (airplaneID) references Aircraft); Queries: ane 2. Print for each flight (whose duration is between 1 hour 15 minutes to 3 hours and 15 minutes-both inclusive): flightNo, fromAirport, toAirport, flightDuration. Query 1 if an airplanelD has no flight, no need to print its info Query 2 - do not worry about time zones. Limit width of flightDuration to 20 columns. Google oracle timestamp functions to work with timestamps (for example, https://stackoverflow.com/questions/257324/oracle-how-t o-add-minutes-to-a-timestamp)

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!