Consider the relational schema given below, where eId of the relation…

GATE · 2014 · CS · Set 3 · Computer Science & IT

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:

ΠempId (employee)−ΠempId (employee⋈(empId=eID)∧(empAge≤depAge)dependent)\Pi_{empId}\:(employee) - \Pi_{empId}\:(employee \bowtie_{(empId=eID) \wedge (empAge \leq depAge)} dependent)

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

  1. A.

    some dependent.

  2. B.

    all dependents.

  3. C.

    some of his/her dependents.

  4. D.

    all of his/her dependents.

Attempted by 188 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…