Open In App

GATE | GATE-CS-2014-(Set-3) | Question 65

Like Article
Like
Save
Share
Report

Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation.

employee (empId, empName, empAge)
dependent(depId, eId, depName, depAge) 

Consider the following relational algebra query:

GATECS2014Q40
The above query evaluates to the set of empIds of employees whose age is greater than that of

(A) some dependent.
(B) all dependents.
(C) some of his/her dependents
(D) all of his/her dependents.


Answer: (D)

Explanation: The below subquery after the subtraction sign produces id’s of those employees who have at least one dependent with age greater than or equal the employee’s age.

GATECS2014Q40 

When the result of above subquery is subtracted from all employees, we get the employees whose age is greater than all dependents.

Quiz of this Question


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads