Non-Additive Join

Question 1

What are the three properties that must hold for a Non Additive Join?

Answer 1

1 - Attribute preservation - Each element of R must be in either R1 or R2

2 - The intersection of R1 and R2 must not be null

3 - Common attribute must be a key in R1 or R2