Referential Integrity

Unofficial Content

Def.:
Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key constraint to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table. It also includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are reflected in the primary table. This definition, may be defined in the database or just implemented by the programs. To choose it, you should use the Referential Integrity Model Property.

Videos

Start Video Defining more transactions
Start Video Relations between entities from reality