What natural joining returns in relational algebra if tables do not have attributes with the same name? Will it be zero or the same as cross-product (Cartesian operator)?
If there are no attributes between the two relationships and you execute natural join, it will return cartesian productfrom the two relationships.
natural join
cartesian product
. , , JOIN , , select WHERE . , , .
it will return the Cartesian product of the tables. If there is a common attribute, then a natural join removes a duplicate of the common attribute