Solution:Step 1: Understand foreign key constraint behaviorA foreign key requires that the referenced value exists in the parent table to maintain data integrity.Step 2: Apply this to the insert statementSince AuthorID 99 does not exist in Authors, the insert violates the foreign key constraint and

[Solved] Given these tables:CREATE TABLE Authors (AuthorID INT PRIMARY KEY, Name VARCHAR(50));CREATE TABLE Books (BookID INT PRIMARY KEY, Title... when there is no author with AuthorID = 99 in Authors? | SQL

SQL - Table Relationships

Given these tables:
CREATE TABLE Authors (AuthorID INT PRIMARY KEY, Name VARCHAR(50));

CREATE TABLE Books (BookID INT PRIMARY KEY, Title VARCHAR(100), AuthorID INT, FOREIGN KEY (AuthorID) REFERENCES Authors(AuthorID));

What happens if you try to insert INSERT INTO Books (BookID, Title, AuthorID) VALUES (1, 'My Book', 99); when there is no author with AuthorID = 99 in Authors?

AThe insert succeeds but AuthorID is set to NULL

BThe insert fails due to foreign key constraint violation

CThe database creates a new author with AuthorID 99 automatically

DThe insert succeeds and adds the book

Step-by-Step Solution

Solution:

Step 1: Understand foreign key constraint behavior
A foreign key requires that the referenced value exists in the parent table to maintain data integrity.
Step 2: Apply this to the insert statement
Since AuthorID 99 does not exist in Authors, the insert violates the foreign key constraint and fails.
Final Answer:
The insert fails due to foreign key constraint violation -> Option B
Quick Check:
Foreign key requires existing parent row = D [OK]

Quick Trick: Foreign key insert fails if parent key missing [OK]

Common Mistakes:

MISTAKES

Assuming automatic creation of missing parent rows
Thinking insert will succeed with NULL foreign key
Ignoring foreign key constraints

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 constraint behavior

Step 2: Apply this to the insert statement

Final Answer:

Quick Check:

Want More Practice?