Question

Jennifer is updating the database for her company. She wants to delete customer records that have not made a purchase from more than 5 years ago but when she tries the database tells her that she can't because she must first delete the customer sales transactions records first. What is this referred to? Group of answer choices
Systems integrity
Referential integrity
Database reliability
Safety system constraints

Answer 1

Referential integrity

Explanation:

Referential integrity is when in a particular database an amount of data is given the same referential value as all other amounts of data. The value of all references are pitted to be equal in this mode.

Here even though Jennifer wants to delete the database for inactive clients she first would have to go through the database of the consumer sale records which might have important information,

Thus here it is a systemic flaw.