Question

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

• A. Union
• B. Set Difference
• C. Cartesian Product
• D. Intersection

Hint:

Remember: \( \times \) means Cartesian Product in relational algebra, while \( \cup \), \( - \), and \( \cap \) are set operators requiring the same schema.

Answer 1

The Correct Option is C

Step 1: Recall the symbol meaning.
In relational algebra, the operator \( \times \) (cross symbol) represents the Cartesian Product. This combines every tuple of the first relation with every tuple of the second relation.
Step 2: Why not the others?

Union (\(\cup\)) combines tuples from two relations, but requires the same schema (same attributes).
Set Difference (\(-\)) removes tuples of one relation from another, also requiring the same schema.
Intersection (\(\cap\)) gives common tuples of two relations, also requiring the same schema.
Cartesian Product (\(\times\)) does not require the same schema; it simply pairs all tuples.

Final Answer: \[ \boxed{\text{Cartesian Product}} \]