The option for referential integrity between the Owner table and the Pet table is cascade and an attempt is made to update the row for Owner 005 in the Owner table (OwnerNum = 005) to have a new OwnerNum of 500. 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 keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine 6./12/2004 Feline 009 400 King 8/15/2007 Canine 009 500 Rex 3/23/2008 Equine 012 600 Slimy 9/21/2005 Reptile 012 700 June Bug 10/9/2001 Equine 009 800 Frisky 12/31/2002 Feline 020 Group of answer choices That row (OwnerNum = 005) will not be updated in the Owner table but the related row(s) in the Pet table will be updated. Nothing will be updated in the Owner table and nothing will be updated in the Pet table. Just that row (OwnerNum = 005) in the Owner table will be updated. Its OwnerNum will change from 005 to 500. There are no related rows in the Pet table. That row (OwnerNum = 005) in the Owner table will be updated to have a new OwnerNum of 500 and so will the related row(s) in the Pet table that refer to it.
The option for referential integrity between the Owner table and the Pet table is cascade and an attempt is made to update the row for Owner 005 in the Owner table (OwnerNum = 005) to have a new OwnerNum of 500. 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 keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table.
Owner TableOwnerNum | LastName | FirstName | Address | City | State | Zip |
---|---|---|---|---|---|---|
005 |
Smith |
Jim |
100 Main |
Dune |
FL |
37465 |
009 |
Jones |
Jane |
3245 West |
Sanford |
FL |
32773 |
012 |
Johnson |
Frank |
2 Century |
Easton |
FL |
37256 |
020 |
Doe |
Sally |
101 Basel |
Orange |
FL |
30998 |
PetNumber | PetName | DOB | Species | OwnerNum |
---|---|---|---|---|
100 |
Fido |
1/1/2005 |
Canine |
009 |
200 |
Ajax |
12/3/2003 |
Canine |
020 |
300 |
Sunshine |
6./12/2004 |
Feline |
009 |
400 |
King |
8/15/2007 |
Canine |
009 |
500 |
Rex |
3/23/2008 |
Equine |
012 |
600 |
Slimy |
9/21/2005 |
Reptile |
012 |
700 |
June Bug |
10/9/2001 |
Equine |
009 |
800 |
Frisky |
12/31/2002 |
Feline |
020 |
Step by step
Solved in 6 steps