Answered step by step
Verified Expert Solution
Link Copied!

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 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.
Team Table
TeamID Name City State
100 Spiders Trenton NJ
200 Mudcats Spring IL
300 Scorpions Tempe AZ
400 Gators Palatka FL
500 Sharks Savannah GA
Player Table
PlayerID FirstName LastName TeamID
5100 Jon Smith 400
5200 Liz Lundy 300
5300 Sally Jones 200
5400 Mike Mason 100
5500 Pat Johnson 400
5600 Ned Nealy 300
5700 Jane Norton 200
Group of answer choices
Just that row (TeamID =200) in the Team table will be updated to a new TeamID of 1200. 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 =200) will not be updated in the Team table but the related row(s) in the Player table will be updated to have a TeamID of 1200.
That row (TeamId =200) in the Team table will be updated to have a TeamID of 1200 and so will the related row(s) in the Player table that refer to it.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases A Beginners Guide

Authors: Andy Oppel

1st Edition

007160846X, 978-0071608466

More Books

Students also viewed these Databases questions

Question

1. Identify six different types of history.

Answered: 1 week ago

Question

2. Define the grand narrative.

Answered: 1 week ago

Question

4. Describe the role of narratives in constructing history.

Answered: 1 week ago