Question 14210 – Database-Management-System

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

What does the above expression generate?

Correct Answer: C

Question 35 Explanation:

The given relational algebra expression will result in employees whose age is not minimum. The
given conditional join, joins the relations if the age is greater than any of the ages mentioned in the database.

Employee numbers of all employees whose age is not the maximum.

Employee numbers of only those employees whose age is the maximum.

Employee numbers of all employees whose age is not the minimum.

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