Referential Integrity Rule in RDBMS

Referential Integrity Rule in DBMS is based on Primary and Foreign Key. The Rule defines that a foreign key have a matching primary key. Reference from a table to another table should be valid.

Referential Integrity Rule example −

<Employee>

<Department>

The rule states that the DEPT_ID in the Employee table has a matching valid DEPT_ID in the Department table.

To allow join, the referential integrity rule states that the Primary Key and Foreign Key have same data types.

David Meador

Published on 03-Jul-2018 17:33:28

• Related Questions & Answers
• Entity Integrity Rule in RDBMS
• RDBMS terminologies
• Integrity Rules in DBMS
• Explain the concept of integrity in DB2 along with types of integrity
• Composite Key in RDBMS
• Secondary Key in RDBMS
• Super Key in RDBMS
• Surrogate Key in RDBMS
• Candidate Key in RDBMS
• Alternate Key in RDBMS
• Foreign Key in RDBMS
• Unique Key in RDBMS
• Future of RDBMS
• Verifying MySQL Package Integrity
• What is Data Integrity?