Question: The option for referential integrity between the Team table and the Player table is cascade and an attempt is made to update the row for
The option for referential integrity between the Team table and the Player table is cascade and an attempt is made to update the row for team TeamID in the Team table to become TeamID What is the result? Use only the data in the question. Do not assume other data exists if it is not present in the tables below. The primary key column TeamID in Team table and PlayerID in Player table is underlined. The foreign key column TeamID in Player table is italicized.
Team Table
TeamID Name City State
Spiders Trenton NJ
Mudcats Spring IL
Scorpions Tempe AZ
Gators Palatka FL
Sharks Savannah GA
Player Table
PlayerID FirstName LastName TeamID
Jon Smith
Liz Lundy
Sally Jones
Mike Mason
Pat Johnson
Ned Nealy
Jane Norton
Group of answer choices
Just that row TeamID in the Team table will be updated to a new TeamID of There are no related rows in the Player table.
Nothing will be updated in the Team table and nothing will be updated in the Player table.
That row TeamId will not be updated in the Team table but the related rows in the Player table will be updated to have a TeamID of
That row TeamId in the Team table will be updated to have a TeamID of and so will the related rows in the Player table that refer to it
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
