Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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: 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started