Cindy tried to delete a customer but the customer still had open invoices so the system would not allow her to delete the custom

Question

jolli1 [7]

3 years ago

11

Cindy tried to delete a customer but the customer still had open invoices so the system would not allow her to delete the custom

er. More than likely ________ was enforced.

Computers and Technology

1 answer:

Verdich [7] · Answer 1 · 2022-04-03T16:11:41+03:00

Answer:

The answer is "Referential integrity".

Explanation:

This relates to one aspect of data integrity. Data across multiple tables are linked via relationships. In view of the distinct customer & invoice tables, each invoice table should have the primary key specified throughout the Customer table, for instance. Whenever the invoice table contains a customer ID reference. This ID including its customer will be only a table of the customer.