For Referential Integrity to Be Maintained?

Referential integrity requires that a foreign key must have a matching primary key or it must be null. This constraint is specified between two tables (parent and child); it maintains the correspondence between rows in these tables. It means the reference from a row in one table to another table must be valid.

Why is it important to maintain referential integrity in a database?

Referential integrity ensures that the relationship between two tables keeps in sync during the execution of the update and delete instructions.

What is used for referential integrity?

A REFERENTIAL INTEGRITY is a database concept that is used to build and maintain logical relationships between tables to avoid logical corruption of data. It is a very useful and important part in RDBMS. Usually, referential integrity is made up of the combination of a primary key and a foreign key.