Question: please provide with hand written answers Q. t Consider the following relations containing airline flight infocmation: Flights Ong: integer, from: string, to: string, distance: integer.

please provide with hand written answers
Q. t Consider the following relations containing airline flight infocmation: Flights Ong:

Q. t Consider the following relations containing airline flight infocmation: Flights Ong: integer, from: string, to: string, distance: integer. departs: time, arrives: time) Aircran (Aid: integer, aname: string, cruising-range: integer) Certified (eid: integer, aid: integer) Employ (gid: integer, ename: string, salary: integer) No&: Employees relation describes pilots and other kinds Of employees as well: every pilot is certified for some aircraft (ocher-wise. he/she would not qualify as a pilot), and only pilots e certified to fly. Write following queries in tuple relational calculus: i) Identifr flights that can be piloted by every pilot whose salary is more than rupee 100,000. ) Find eids Of employees who are certified for exactly aircraft- i) Find tyr eids of employees who make the highest salary. iv) Find tyr eids of employees who are certified for the z_largest number Of aircraft.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!