Question

Identify the operation which is NOT one of the parts of the fivebasic set operations in relational algebra?

? Join

? Union

? Cartesian Product

? Set Difference

Answer 1

Answer:

Join

Explanation:

Five basic set operators in relational algebra are as follows:

• Selection - tuple selection
• Projection - extract columns
• Cartesian product - cross product of relations
• Set union - union of two relations
• Set difference - minus operation on two relations

As we can see, Join is not part of the basic set operations but it is implemented using the Cartesian Product operator.