The following tables form part of a database held in a Relational Database Management System:
Formulate the following queries in relational algebra, tuple relational calculus, and domain relational calculus (the answers to these queries in SQL are given in the next section).
(1) List all Boeing aircraft.
(2) List all Boeing 737 aircraft.
(3) List the employee numbers of pilots certified for Boeing aircraft.
(4) List the names of pilots certified for Boeing aircraft.
(5) List the aircraft that can fly nonstop from Glasgow to New York (flyingRange > flightDistance).
(6) List the employee numbers of employees who have the highest salary.
(7) List the employee numbers of employees who have the second highest salary.
(8) List the employee numbers of employees who are certified for exactly three aircraft.
Correct Answer:
Verified
(2) (3) (4) (5) (6)RA: To answe...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q1: Describe the main characteristics of the Relational
Q2: The Relational and CODASYL models are examples
Q3: Describe the difference between a base relation
Q4: From an SQL user's perspective, does the
Q5: Choose any four relational algebra operators and
Q6: Given two relations R and S,
Q7: A relational database contains details about journeys
Q8: The following tables form part of a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents