Q.1. Does theta join operator requires following union compatibility requirements?:
- Same number of columns
- Domain of corresponding columns should be same
I feel no, since I came across following fact:
$\sigma_\theta( R_1\times R_2)=R_1⋈_\theta R_2$
But I need confirmation.
Q.2. Since theta join can be represented in terms of cartesian product and selection as shown above, does it mean columns of resultant relation will contain ALL columns from both $R_1$ and $R_2$?