Ask Question
3 April, 18:09

The WorkOrders table contains a foreign key, ClientNum, which must match the primary key of the Client table. What type of update to the WorkOrders table would violate referential integrity? If deletes do not cascade, what type of update to the Client table would violate referential integrity? If deletes do cascade, what would happen when a client was deleted?

+1
Answers (1)
  1. 3 April, 21:41
    0
    Changing the customer number on a record in the Orders table to a number that does not match a customer number in the customer table would violate referential integrity.

    If deletes do not cascade, deleting a customer that has orders would violate referential integrity.

    If deletes cascade, customer can be deleted and all orders for that customer will automatically be deleted.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “The WorkOrders table contains a foreign key, ClientNum, which must match the primary key of the Client table. What type of update to the ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers