Solution:Step 1: Understand foreign key enforcement on insertThe foreign key requires DeptID in Employees to exist in Departments.Step 2: Analyze the insert statementSince DeptID 10 does not exist in Departments, the insert violates the foreign key constraint and fails.Final Answer:The insert fails

[Solved] Given these tables:CREATE TABLE Departments (DeptID INT PRIMARY KEY, DeptName VARCHAR(50));CREATE TABLE Employees (EmpID INT PRIMARY KEY, EmpName... when there is no department with DeptID 10? | SQL

SQL - Table Relationships

Given these tables:
CREATE TABLE Departments (DeptID INT PRIMARY KEY, DeptName VARCHAR(50));

CREATE TABLE Employees (EmpID INT PRIMARY KEY, EmpName VARCHAR(50), DeptID INT, FOREIGN KEY (DeptID) REFERENCES Departments(DeptID));

What happens if you try to insert INSERT INTO Employees VALUES (1, 'Alice', 10); when there is no department with DeptID 10?

AThe insert fails due to foreign key constraint violation.

BThe insert succeeds and adds the row.

CThe insert succeeds but sets DeptID to NULL.

DThe insert deletes the Departments table.

Step-by-Step Solution

Solution:

Step 1: Understand foreign key enforcement on insert
The foreign key requires DeptID in Employees to exist in Departments.
Step 2: Analyze the insert statement
Since DeptID 10 does not exist in Departments, the insert violates the foreign key constraint and fails.
Final Answer:
The insert fails due to foreign key constraint violation. -> Option A
Quick Check:
Foreign key violation blocks insert = The insert fails due to foreign key constraint violation. [OK]

Quick Trick: Foreign key blocks inserts with missing referenced keys [OK]

Common Mistakes:

MISTAKES

Assuming insert succeeds without referenced key
Thinking foreign key sets missing values to NULL
Believing foreign key deletes other tables

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given these tables:

Step 1: Understand foreign key enforcement on insert

Step 2: Analyze the insert statement

Final Answer:

Quick Check:

Want More Practice?