Definition
Cartesian Product (Relational Algebra)
The Cartesian product between two relations consist of all possible combinations of tuples from both relations.
Note that in relational algebra, the Cartesian product is associative since there are no “nested” attributes.