Question

What action does  ⋈  operator perform in relational algebra

(a) Output specified attributes from all rows of the input relation and remove duplicate tuples from the output

(b) Outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name

(c) Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)

(d) Return rows of the input relation that satisfy the predicate

I had been asked this question in class test.

My question is from Introduction to the Relational Model in chapter Introduction to Relational Model and Sql of RDBMS

Answer 1

Correct answer is (a) Output specified attributes from all rows of the input relation and remove duplicate tuples from the output

The best explanation: ⋈ Outputs specified attributes from all rows of the input relation. Remove duplicate tuples from the output. The operation is called the join operation.