Given the relations employee (name, salary, dept-no), and department (dept-no,…
2016
Given the relations
employee (name, salary, dept-no), and
department (dept-no, dept-name, address)
Which of the following queries cannot be expressed using the basic relational algebra operations (σ, π, x, -, ∪, ρ)
- A.
Department address of every employee
- B.
Employees whose name is the same as their department name
- C.
The sum of all employees’ salaries
- D.
All employees of a given department
Attempted by 170 students.
Show answer & explanation
Correct answer: C
Basic relational algebra operations cannot compute aggregate values such as the sum of all employees' salaries. Aggregation requires an extended relational algebra operator.
A video solution is available for this question — log in and enroll to watch it.