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 empId s of employees whose age is greater than that of
Topic-wise GATE CS PYQs with verified steps
