The Wayback Machine - https://web.archive.org/web/20040925215651/http://databases.about.com:80/cs/administration/g/refintegrity.htm

You are here:

Home

Databases

Stay up to date!

Email to a friend Print this page

What's Hot

SQL Books Entity-Relationship Diagram Triggers Modifying a Query in Microsoft Access How To Create an Adobe PDF File From an Access Database

“Referential Integrity”

Glossary

From Mike Chapple,
Your Guide to Databases.
FREE Newsletter. Sign Up Now!

Definition: Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key 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.

Consider the situation where we have two tables: Employees and Managers. The Employees table has a foreign key attribute entitled ManagedBy which points to the record for that employee’s manager in the Managers table. Referential integrity enforces the following three rules:

We may not add a record to the Employees table unless the ManagedBy attribute poi
If the primary key for a record in the Managers table changes, all corresponding records in the Employees table must be modified using a cascading update.
If a record in the Managers table is deleted, all corresponding records in the Employees table must be deleted using a cascading delete.

	Topic Index	back to top

email to a friend font size

Aug	SEP	Oct
	25
2003	2004	2005

FREE Newsletter

Most Popular

What's Hot

“Referential Integrity”