Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions