Question

What is cartesian product?How it is related to join?

Answer 1

Answer:

The Cartesian product, also referred to as a cross-join, returns all the rows in all the tables listed in the query. Each row in the first table is paired with all the rows in the second table. This happens when there is no relationship defined between the two tables.

Answer 2

Answer:

Cartesian join or cross join is the product of all the rows in table. Cartesian join returns the every value in first table paired with all the values in second table.

Step-by-step explanation:

For example we have 10 touples in Customer table and 10 touples in orders table we will get 100 total touples in resultant table.

To prevent from this we use relation condition .So only those tables will be prpjected that satisfies the given condition.