A database's lack of referential integrity can cause relational databases to return incomplete data, often with no indication of an error.
When a foreign key has more than one primary key value, referential integrity is violated. If referential integrity is not enforced, data inconsistency and data loss may occur. When you enforce referential integrity and check the Cascade Delete Related Records check box, Access deletes all records that reference the primary key when you delete the primary key record. The Database Engine generates an error, and the delete or update action on the row in the parent table is undone. CASCADE. When a row in the parent table is updated or deleted, the corresponding rows in the referencing table are updated or deleted.
Learn more about database here-
https://brainly.com/question/25198459
#SPJ4
