Relational Algebra

A natural join combines two relations based on common attributes.
Given: and , the common attribute is .
During a natural join:
- Matching tuples from both relations based on the value of common attribute are joined.
- The result includes all attributes from both relations, but the common attribute appears only once.
Therefore, the resulting schema will be: , where: - is from relation ,
- is the common attribute, and
- is from relation .
This confirms that option (3) is correct.