Q1.23

MCQ1 mark, −0.25

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 $\left(\sigma, \pi,\times ,\Join, \cup, \cap,-\right)$ ?

(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

Loading…