he relati
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Question
Here are examples of how to solve the problems:
List the name and age of all users under age 18.
{ U.name, U.age | User(U) U.age < 18 }
List the title and the year of all books published after 1960.
{ B.title, B.year | Book(B) B.year > 1960 }
Please solve the problem using relational calculus.
Transcribed Image Text:Formulate the following queries in the relational calculus:
PHOTE
S HILA
SZEG
4. List the name and the fleet size of all carriers employing more than 50000 workers.
5. List all flights leaving from United States airports.
6. List the carrierID and the distance of all flights landing in NY state airports.
7. List the carriers that do not leave from JFK.
8. List the names of carriers that have flights landing in France airports.
Transcribed Image Text:Consider the following database instance.
Airport
airportID
CDG
DXB
JFK
LGA LaGuardia
ΜΙΑ
SFO
Carrier
carrierID
AF
DL
EK
US
Flight
carrierID
DL
DL
DL
EK
US
DL
AF
US
AF
name
Charles de Gaulle
Dubai International
John F Kennedy International
Miami International
San Francisco International
name
Air France
Delta Air Lines
Emirates Airline
US Airways
flightNo date
city
time
426 10/16/2017
7:00 AM
426 10/17/2017
7:00 AM
479 10/16/2017 7:25 PM
721 10/17/2017 11:25 AM
783 10/17/2017 3:20 AM
1472 10/17/2017
7:30 AM
3577 10/17/2017
5:45 PM
3577 10/17/2017
9:40 AM
3634 10/16/2017 1:20 PM
state
Paris
Dubai
New York
NY
New York
NY
Miami
FL
San Francisco CA
fleetSize employees revenue
225
84,602
15,414
855
80,000
39,639
239
84,153
18,300
338
31,467
13,050
country
FRA
UAE
USA
USA
USA
USA
airportID destination distance
JFK
SFO
2,586
JFK
SFO
2,586
JFK
SFO
2,586
CDG
DXB
3,259
DXB
JFK
6,843
LGA
ΜΙΑ
1,099
JFK
CDG
LGA
SFO
CDG
ΜΙΑ
3,629
2,576
4,580
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
