TASK 2: Airline flight information Using domain and tuple relational calculus, find: 1. Find the eids of pilots certified for some Boeing aircraft. 2. Find the names of pilots certified for some Boeing aircraft. 3. Find the aids of all aircraft that can be used on non-stop flights from Paris to Vancouver. 4. Find the names of pilots who can operate planes with a range greater than 3,000 miles but are not certified on any Boeing aircraft. 5. Find the eids of employees who make the highest salary (multiple employees can have highest salary). Relation Flights Aircraft Certified Relational schema FLIGHTS(flno, from, to, distance, departs, arrives) AIRCRAFT (aid, aname, cruisingrange) CERTIFIED (#eid, #aid) Employees EMPLOYEES(eid, ename, salary)
TASK 2: Airline flight information Using domain and tuple relational calculus, find: 1. Find the eids of pilots certified for some Boeing aircraft. 2. Find the names of pilots certified for some Boeing aircraft. 3. Find the aids of all aircraft that can be used on non-stop flights from Paris to Vancouver. 4. Find the names of pilots who can operate planes with a range greater than 3,000 miles but are not certified on any Boeing aircraft. 5. Find the eids of employees who make the highest salary (multiple employees can have highest salary). Relation Flights Aircraft Certified Relational schema FLIGHTS(flno, from, to, distance, departs, arrives) AIRCRAFT (aid, aname, cruisingrange) CERTIFIED (#eid, #aid) Employees EMPLOYEES(eid, ename, salary)
Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter11: Sql Server Databases
Section: Chapter Questions
Problem 1MQ1
Related questions
Question
Transcribed Image Text:TASK 2: Airline flight information
Using domain and tuple relational calculus, find:
1. Find the eids of pilots certified for some Boeing aircraft.
2. Find the names of pilots certified for some Boeing aircraft.
3. Find the aids of all aircraft that can be used on non-stop flights from Paris to Vancouver.
4. Find the names of pilots who can operate planes with a range greater than 3,000 miles but are not certified
on any Boeing aircraft.
5. Find the eids of employees who make the highest salary (multiple employees can have highest salary).
Relation
Flights
Aircraft
Certified
Relational schema
FLIGHTS(flno, from, to, distance, departs, arrives)
AIRCRAFT (aid, aname, cruisingrange)
CERTIFIED (#eid, #aid)
Employees
EMPLOYEES(eid, ename, salary)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
