A student has used the following query to retrieve data from the Employee table (it has 8 records) and the Department table (it has 4 records). The result of his query is 32 records in the output table. What is wrong with his query?

SELECT Employee.First_Name, Employee.Last_Name, Department.Depart_Name
FROM Employee, Department

Question

A student has used the following query to retrieve data from the Employee table (it has 8 records) and the Department table (it has 4 records). The result of his query is 32 records in the output table. What is wrong with his query?

SELECT Employee.First_Name, Employee.Last_Name, Department.Depart_Name
FROM Employee, Department

BlackTom AI · Accepted Answer

The scenario describes a student querying two tables, Employee (8 records) and Department (4 records), and getting 32 rows in the result. This multiplication of 8 by 4 indicates a Cartesian product, meaning every row from Employee is paired with every row from Department.

Option 1: The student has to use WHERE to connect PK and FK in the relationship.
This is the correct diagnostic. Without a join condition linking Employee and Department on their related keys (for example, a foreign key in Employee referencing Department), SQL performs a cross join, producing 8 × 4 = 32 rows. Adding a proper join condition in the WHERE clause (or using an explicit JOIN ... ON ... syntax) would pair each employee with only their corresponding department, reducing the result to the expected number of related records.

Option 2: The student has to use HAVING to connect PK and FK in the relationship.
HAVING is used to filter results of an aggregate query after GROUP BY, not to establish join relationships between tables. This option misuses HAVING; it would not fix the root cause of the Cartesian product.

Option 3: The student has to query from one table only.
The task involves data from both Employee and Department, so querying a single table would miss needed information. The issue is not about needing fewer tables, but about linking them correctly.

Option 4: The student has to ORDER BY the results in ascending order.
ORDER BY controls the order of the output but does not affect the number of rows returned or how tables are joined. It would not resolve the 32-row Cartesian result.

In summary, the excessive row count arises because there is no join condition between Employee and Department, causing a Cartesian product. Adding a proper join predicate connects related records and yields the correct, typically fewer, result set.

BUS-308-03 Quiz 4: SQL Design & Query

View Explanation

Log in for full answers

Similar Questions

In a consumer society, many adults channel creativity into buying things

Economic stress and unpredictable times have resulted in a booming industry for self-help products

People born without creativity never can develop it

A product has a selling price of $20, a contribution margin ratio of 40% and fixed cost of $120,000. To make a profit of $30,000. The number of units that must be sold is: Type the number without $ and a comma. Eg: 20000

Which of the following statement regarding cost is correct:

Under the assumptions used in cost-volume-profit analysis, as the activity increases:

The CVP and break-even analysis are supported by a range of important assumptions. Which of the following is not an assumption of the CVP:

The break-even point is that at which:

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler