(Contents)(Previous)(Next)

Referential Integrity

What does referential integrity mean?

Referential integrity means the monitoring and maintenance of consistency conditions existing between specific tables. If, e.g., entries of the employees table refer to the department table, it can be ensured that these references do not lead to empty columns, i.e., to non-existent departments. It can also be stipulated that, e.g., departments cannot be deleted as long as there are employee entries referring to them.


(Contents)(Previous)(Next)