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 200(TeamID =200) in the Team table to become 1200(TeamID 1200). 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.
 The option for referential integrity between the Team table and the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!