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

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 11:00, kingethan08

Ihave an iphone 8plus should i get another phone like samsung note 9 or s9 ? ?

Answers: 2

continue

Computers and Technology, 23.06.2019 02:00, magicalunicorns47

Arecipients list has been loaded into a document. which commands should be clicked in order to filter the list so that letters will not be printed for recipients who live in a certain state? mailings tab, start mail merge, select recipients, type new list, then insert only contacts from the desired states mailings tab, rules, select recipients, use existing list, then choose a recipients list that includes only contacts in certain states mailings tab, select recipients, use existing list, rules, fill in, then type in certain states mailings tab, rules, skip record select “state” under field name, then type in the state name under “equal to”

Answers: 2

continue

Computers and Technology, 25.06.2019 01:00, dlatricewilcoxp0tsdw

Your computer will organize files into order. alphabetical chronological size no specific

Answers: 2

continue

Computers and Technology, 25.06.2019 06:50, gutierrezaandrea56

The federal sentencing guidelines for organizations set the tone for organizational ethics compliance programs by question 1 options: a) codifying into law incentives for organizations to take action such as developing ethical compliance programs to prevent misconduct. b) forcing all organizations to develop mandatory reporting systems and ethics programs. c) eliminating most of the federal legislation that created inefficient and time-consuming activities for businesses. d) providing detailed guidelines for how to set up organizational ethics programs to guard against unethical conduct. e) providing a thorough examination of company codes of ethics to determine whether they are sufficient.

Answers: 1

continue

Do you know the correct answer?

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