Computers and Technology, 18.03.2021 01:10 Vells962

Consider the following relations containing airline flight information: Flights(flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time)
Aircraft(aid: integer, aname: string, cruisingrange: integer)
Certified(eid: integer, aid: integer)
Employees(eid: integer, ename: string, salary: integer)

Note that the Employees relation describes pilots and other kinds of employees as well; every pilot is certified for some aircraft (otherwise, he or she would not qualify as a pilot), and only pilots are certified to fly. Write the following queries in tuple relational calculus, domain relational calculus and SQL. Note: You might want to try writing these queries in relational algebra before formulating them in tuple and domain relational calculus

a. Find the eids of pilots certified for some Boeing aircraft.
b. Find the names of pilots certified for some Boeing aircraft.
c. 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.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 21.06.2019 18:00

Amara created a workbook to track the number of minutes she reads each week. each day, she entered the number of minutes into the workbook. identify the types of data in the workbook using the drop-down menus.

Answers: 3

Answer

Computers and Technology, 21.06.2019 18:20

Write a javascript program that reads three integers named start, end, and divisor from three text fields. your program must output to a div all the integers between start and end, inclusive, that are evenly divisible by divisor. the output integers must be separated by spaces. for example, if a user entered 17, 30, and 5, your program would output "20 25 30" (without the quotes) because those are the only integers between 17 and 30 (including 17 and 30) that are evenly divisible by 5.

Answers: 2

Answer

Computers and Technology, 22.06.2019 10:00

Jackson is teaching the decimal number system. he wants his students to know how to expand numbers by powers of 10. which is the correct order in which digits are assigned values in the decimal number system?

Answers: 1

Answer

Computers and Technology, 23.06.2019 13:00

Which of the following statements is false? a. a class can directly inherit from class object. b. if the class you're inheriting from declares instance variables as private, the inherited class can access those instance variables directly. c. a class's instance variables are normally declared private to enforce good software engineering. d. it's often much more efficient to create a class by inheriting from a similar class than to create the class by writing every line of code the new class requires.

Answers: 3

Answer

You know the right answer?

Consider the following relations containing airline flight information: Flights(flno: integer, from...

Questions