Given the relations employee (name, salary, dept-no), and department (dept-no,…
GATE · Computer Science · 2000
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 (σ,π,×,⋈,∪,∩,−)?
- 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 638 students.
Sign up free to check your answer
Sign up freeLoading lesson…