Chapter 5, Problem 14RQ

Explanation of Solution

Cartesian join:

• It is the formal name for multiplying two tables.
• It is also called as “CROSS JOIN” that returns the result that contains the product of number of rows in the first and second table.
• If “WHERE” clause is used in “CROSS JOIN” then it works like “INNER JOIN”.

Syntax:

SELECT table_Name1.column_Name1, table_Name2.column_Name2… FROM table_Name1, table_Name2,…;

Performing Cartesian join:

Creating tables:

CREATE TABLE cseitstudent(studentID INT, sname VARCHAR(30), department VARCHAR(5), sem INT);

CREATE TABLE placement(PlacementID INT,StudentID INT, departme...