The following relation records the age of 500 employees of a company, where…

PYQ GATE 2021

The following relation records the age of 500 employees of a company, where empNo ( indicating the employee number) is the key: 

empAge(empNo‾,age)empAge(\underline{empNo},age)

Consider the following relational algebra expression: 

ΠempNo(empAge⋈(age>age1)ρempNo1,age1(empAge))\Pi_{empNo}(empAge \Join_{(age>age1)} \rho_{empNo1,age1}(empAge))

 What does the above expression generate?

  1. A.

    Employee numbers of only those employees whose age is the maximum

  2. B.

    Employee numbers of only those employees whose age is more than the age of exactly one other employee

  3. C.

    Employee numbers of all employees whose age is not the minimum

  4. D.

    Employee numbers of all employees whose age is the minimum

Attempted by 284 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…