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 800(PetNumber =800 and OwnerNum =020) in the Pet table to be assigned to owner Jane Jones (OwnerNum =009). 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.
 The option for referential integrity between the Owner 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!