Referential Integrity is used to maintain the accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constrains.
Referential Integrity is important in DBMS as:
- It prevents the entry of duplicate data.
- It prevents one table from pointing to a nonexistent field in another table.
- It prevents consistency between “Partnered” tables.
- It prevents the deletion of a record that contains a value referred to by a foreign key in another table.
- It prevents the addition of a record to a table that contains a foreign key unless key unless there is primary key in the linked table.
