Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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
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
See similar textbooks
icon
Related questions
Question
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)
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
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS