Which operation allows us to find tuples that are in one relation but are not…

2024

Which operation allows us to find tuples that are in one relation but are not in another relation?

  1. A.

    Cartesian Product Operation

  2. B.

    The Union Operation

  3. C.

    The Set – Difference Operation

  4. D.

    The Set Intersection Operation

  5. E.

    Question not attempted

Attempted by 273 students.

Show answer & explanation

Correct answer: C

To find tuples that are in one relation but not in another, we need an operation that returns elements exclusive to the first relation. Let’s analyze each operation: Cartesian Product: Combines every tuple from the first relation with every tuple from the second. It produces all possible pairs, not tuples exclusive to one relation. Union: Combines all tuples from both relations, removing duplicates. It includes tuples from both, not just those in one. Set Difference: Returns tuples that are in the first relation but not in the second. This operation specifically identifies tuples exclusive to one relation. Set Intersection: Returns only tuples common to both relations. It does not identify tuples exclusive to one. Therefore, the correct operation is Set Difference.

Explore the full course: Up Lt Grade Assistant Teacher 2025