Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following tables form an instance of an Airport Database held in a relational DBMS: Airport (airportID, name, city, state, country) Carrier (carrierID, name, fleetSize,

image text in transcribed
image text in transcribed
The following tables form an instance of an Airport Database held in a relational DBMS: Airport (airportID, name, city, state, country) Carrier (carrierID, name, fleetSize, employees, revenue) Flight (carrierID, flightNo, date, time, airportID, destination, distance) Airnart - Each airport name is unique in its country. Carrier - Each carrier name is unique in the whole world. - Any (carrierID, flightNo) combination is unique for the whole day. B) Relational Algebra Ouestions: Using the instance of the Airport database, formulate the following queries in the relational algebra: 1. List all airport names. 2. List full details of all airports located outside the United States. Note: You should use the not equal sign = in this query. 3. List the name and the state of all United States airports. 4. List the name and the fleet size of all carriers employing more than 50000 workers. 5. List the carrier name, the carrieriD, the flightNo and the date of all flights. 6. Display the number of airports. 7. Display the number of flights with distances longer than 3000 miles. 8. Display the number of all carriers and the average of their revenues. 9. Display the number of flights leaving from JFK and the total of their distances. 10. Display the minimum, the average, and the maximum distances of the flights that are scheduled on October 17 th, 2017

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Management And Supervision Wiley Ronald Institute Of Internal Auditors Professional Book Series

Authors: Gil W. Courtemanch, Guilbert W. Courtemanche

1st Edition

0471625655, 978-0471625650

More Books

Students also viewed these Accounting questions

Question

Write short notes on departmentation.

Answered: 1 week ago

Question

What are the factors affecting organisation structure?

Answered: 1 week ago

Question

What are the features of Management?

Answered: 1 week ago

Question

Briefly explain the advantages of 'Management by Objectives'

Answered: 1 week ago