[Solved] You have these tables:CREATE TABLE Teams (TeamID INT PRIMARY KEY);CREATE TABLE Players (PlayerID INT PRIMARY KEY, TeamID INT, FOREIGN KEY... And what happens if the TeamID is updated in Teams? | SQL

SQL - Table Relationships

You have these tables:

CREATE TABLE Teams (TeamID INT PRIMARY KEY);
CREATE TABLE Players (PlayerID INT PRIMARY KEY, TeamID INT, FOREIGN KEY (TeamID) REFERENCES Teams(TeamID) ON DELETE SET NULL ON UPDATE CASCADE);

If a team is deleted, what happens to the players belonging to that team? And what happens if the TeamID is updated in Teams?

APlayers are deleted on team delete; TeamID update fails

BPlayers' TeamID is set to NULL on delete; updated automatically on TeamID change

CPlayers remain unchanged on delete; TeamID update cascades

DDelete and update both fail due to foreign key constraints

Step-by-Step Solution

Solution:

Step 1: Analyze ON DELETE SET NULL effect
When a team is deleted, players' TeamID is set to NULL.
Step 2: Analyze ON UPDATE CASCADE effect
If TeamID changes, players' TeamID updates automatically to match.
Final Answer:
Players' TeamID is set to NULL on delete; updated automatically on TeamID change -> Option B
Quick Check:
ON DELETE SET NULL + ON UPDATE CASCADE behavior [OK]

Quick Trick: ON DELETE SET NULL nullifies; ON UPDATE CASCADE updates keys [OK]

Common Mistakes:

MISTAKES

Assuming players are deleted on team delete
Thinking updates fail with cascade
Ignoring nullability requirement for SET NULL

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

You have these tables:

Step 1: Analyze ON DELETE SET NULL effect

Step 2: Analyze ON UPDATE CASCADE effect

Final Answer:

Quick Check:

Want More Practice?