Natural join if no common attributes

relational-database relational-algebra
Hate picture Hate · Jan 27, 2013 · Viewed 15.9k times · Source

What will natural join return in relational algebra if tables don't have attributes with same names? Will it be null or the same as cross-product (Cartesian operator)?

Answer

Andrew Martin picture Andrew Martin · Feb 10, 2013

If there are no attributes in common between two relations and you perform a natural join, it will return the cartesian product of the two relations.

Related questions

Difference between a theta join, equijoin and natural join

I'm having trouble understanding relational algebra when it comes to theta joins, equijoins and natural joins. Could someone please help me better understand it? If I use the = sign on a theta join is it exactly the same as just …

Read More
How can I find MAX with relational algebra?

Working with databases, how can I find MAX using relational algebra?

Read More
Algebra Relational sql GROUP BY SORT BY ORDER BY

I wanted to know what is the equivalent in GROUP BY, SORT BY and ORDER BY in algebra relational ?

Read More