![GATE 2014 [Set-3]](https://solutionsadda.in/wp-content/uploads/2019/05/green-new-logo.png){kind=logo}
ER-Model
December 11, 2023GATE 2008
December 11, 2023GATE 2014 [Set-3]
| Question 40 |
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)
The above query evaluates to the set of empIds of employees whose age is greater than that of
| some dependent. | |
| all dependents. | |
| some of his/her dependents. | |
| all of his/her dependents. |
Question 40 Explanation:
The inner query selects the employees whose age is less than or equal to at least one of his dependents. So, subtracting from the set of employees, gives employees whose age is greater than all of his dependents.
Correct Answer: D
Question 40 Explanation:
The inner query selects the employees whose age is less than or equal to at least one of his dependents. So, subtracting from the set of employees, gives employees whose age is greater than all of his dependents.