Define referential integrity

Define referential integrity.

It is the rules that are applied when the relationships are created. It ensures integrity of data and prevents inconsistent data into the tables.

Define referential integrity.

Referential integrity is a RDBMS concept and ensures the relationships among tables remain consistent. Data integration (correctness of data) and preventing inconsistent data are ensured by referential integrity. This concept has two keys namely primary key and foreign key. Among the tables, one table should contain primary key and other(s), foreign key. Foreign key specifies that the values in that column must not be other than the values available in the table which has primary key