- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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>
| EMP_ID | EMP_NAME | DEPT_ID |
<Department>
| DEPT_ID | DEPT_NAME | DEPT_ZONE |
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.
Published on 03-Jul-2018 17:33:28
- Related Questions & Answers
- Entity Integrity Rule in RDBMS
- RDBMS terminologies
- Integrity Rules in DBMS
- 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
- Explain the concept of integrity in DB2 along with types of integrity
- Verifying MySQL Package Integrity
- What is Data Integrity?
Advertisements