Given the relations

employee (name, salary, deptno) and

department (deptno, deptname, address)

Which of the following queries cannot be expressed using the basic relational algebra operations (U, -, x, π, σ, p)?  

1
Department address of every employee
2
Employees whose name is the same as their department name
3
The sum of all employees' salaries
4
All employees of a given department
5
Question Not Attempted

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation