Which operation requires two relations as input to form a new relation and…
2024
Which operation requires two relations as input to form a new relation and these two relations must have a common attribute?
- A.
Division operation
- B.
Cartesian product operation
- C.
Natural join operation
- D.
Projection operation
- E.
Question not attempted
Attempted by 341 students.
Show answer & explanation
Correct answer: C
The operation that requires two relations as input and a common attribute between them is the Natural Join. It combines tuples from two relations based on matching values in the common attribute(s). This operation is defined only when there is at least one common attribute between the two relations. Other operations like Cartesian Product or Division do not require a common attribute, and Projection operates on a single relation. Therefore, the correct choice is the Natural Join operation.