Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started