The following tables form part of a database held in a Relational Database Management System:
Formulate the following queries in SQL (the answers to these queries in relational algebra, tuple relational calculus, and domain relational calculus were given in the previous 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
FROM Aircraft
WHERE aName = ...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q2: Consider the following relational schema:
Q3: The following tables form part of a
Q4: The following tables form part of a
Q5: The relational schema shown below is part
Q6: A relational database contains details about journeys
Q8: Write SQL*Plus commands to do the following:
Q9: Assume that the following table is created
Q10: What is a sequence? Write an SQL
Q11: (a) What is a 'table' and what
Q12: (a) What is a named block
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