Question:medium

Identify the relational algebra operation denoted by: \[ \text{Course X Student;} \] where 'Course' and 'Student' are two relations and X is an operation.

Show Hint

Remember: \( \times \) means Cartesian Product in relational algebra, while \( \cup \), \( - \), and \( \cap \) are set operators requiring the same schema.
Updated On: Feb 16, 2026
  • Union
  • Set Difference
  • Cartesian Product
  • Intersection
Show Solution

The Correct Option is C

Solution and Explanation

Step 1: Understand the symbol's meaning.
In relational algebra, the operator \( \times \) (cross symbol) denotes the Cartesian Product. This operation forms new tuples by combining each tuple from the first relation with every tuple from the second relation.
Step 2: Evaluate alternative operators.

Union (\(\cup\)) merges tuples from two relations, but necessitates identical schemas (same attributes).
Set Difference (\(-\)) subtracts tuples of one relation from another, also requiring identical schemas.
Intersection (\(\cap\)) identifies common tuples between two relations, also requiring identical schemas.
Cartesian Product (\(\times\)) does not impose schema constraints; it systematically pairs all tuples.

Final Answer: \[\boxed{\text{Cartesian Product}}\]
Was this answer helpful?
0


Questions Asked in CUET (UG) exam