Given the relations employee(name, salary, deptno), and department(deptno,…

PYQ GATE 2000

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 (σ, π, ×, ⋈, ∪, ∩, −)?

  1. A.

    Department address of every employee

  2. B.

    Employees whose name is the same as their department name

  3. C.

    The sum of all employees’ salaries

  4. D.

    All employees of a given department

Attempted by 199 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…