In SQL, which of the following is/are the basic operations in relational algebra?

Explanation

Select, Project, and Union are the basic operations in relational algebra Important Points SELECT (σ) The SELECT operation is used for selecting a subset of the tuples according to a given selection condition. Projection(π) The projection eliminates all attributes of the input relation but those mentioned in the projection list. The projection method defines a relation that contains a vertical subset of Relation. Union operation (υ) It includes all tuples that are in tables X or in Y. It also eliminates duplicate tuples. So, set A UNION set B would be expressed as The result <- X ∪ Y Additional Information Unary Relational Operations SELECT (symbol: σ) , PROJECT (symbol: π) , RENAME (symbol: ρ) Binary Relational Algebra Operation UNION (υ) , INTERSECTION ( ),DIFFERENCE (-),CARTESIAN PRODUCT ( x ) Binary Relational Operations JOIN & DIVISION Therefore All of the Options is the correct answer