Question

consider the following relation istances R1 and R2​

Answer 1

Answer:

Database Management Systems | Set 1

Following questions have been asked in GATE CS exam.

1. 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)? (GATE CS 2000)

(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

Answer: (c)

Explanation:

The six basic operators of relational algebra are the selection(σ ), the projection(π), the Cartesian product (x) (also called the cross product or cross join), the set union (U), the set difference (-), and the rename (p). These six operators are fundamental in the sense that none of them can be omitted without losing expressive power. Many other operators have been defined in terms of these six. Among the most important are set intersection, division, and the natural join, but aggregation is not possible with these basic relational algebra operations. So, we cannot run sum of all employees’ salaries with the six operations.

References:

Answer 2

Explanation:

➡️R1 U R2=(Amit, sunil, radha,ankit,radha,ojas,)

➡️R1 x R2=(Amit, Ankit)(Amit, Sunil) (Amit, radha) (Amit ,Amit)(sunil, Ankit)(sunil, sunil) (sunil, radha) (ojas, ankit) (ojas, sunil) (ojas, radha) (radha, ankit) (radha, Sunil) (radha, radha) (radha, amit))

➡️R1 Π R2=(Amit, sunil, radha)