Question

List fundamental operations of relational algebra. Explain any two of them.​

Answer 1

Answer:

1. selection
2. Projection
3. Cartesian product
4. Union
5. Set difference

Explanation:

Projection: Projection operator (π) is a unary in relational algebra that performs a projection operation. It displays the columns of a relational or a table based on a specified attributes.

Set difference: Set difference in relational algebra is the same operation as in set theory with the constraint that both relation should have same set of attributes.