Question: The option for referential integrity between the Owner table and the Pet table is restrict and an attempt is made to update the row for
The option for referential integrity between the Owner table and the Pet table is restrict and an attempt is made to update the row for pet PetNumber and OwnerNum in the Pet table to be assigned to owner Jane Jones OwnerNum 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.
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
