The Cartesian Product is a fundamental operator in relational algebra.
⇒ Cartesian Product combines information from two different relations into one.
⇒ Generally a Cartesian Product is not a meaningful operation when performed alone. However, it becomes meaningful when followed by other operations, typically select operations.
Symbol: ×
Notation: R1 × R2
1. If relations R1 and R2 have a and b attributes respectively, then the resulting relation will have a + b attributes from both input relations.
2. If relations R1 and R2 have n1 and n2 tuples respectively, then the resulting relation will have n1 × n2 tuples, combining each possible pair of tuples from both relations.
3. If both input relations have attributes with the same name, change the name of the attribute to "relation_name.attribute_name" to avoid ambiguity.
