The Orders table contains a foreign key, CustomerNum, that must match the primary key of the Customer

Question:

The Orders table contains a foreign key, CustomerNum, that must match the primary key of the Customer table. What type of update to the Orders table would violate referential integrity? If deletes do not cascade, what type of update to the Customer table would violate referential integrity? If deletes do cascade, what would happen when a customer was deleted?
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts of Database Management

ISBN: 978-111182591

7th edition

Authors: Philip J. Pratt, Joseph J. Adamski

Question Posted: