2007-07-08 22:38:27 · 3 answers · asked by dina 1 in Computers & Internet ➔ Computer Networking
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.
2007-07-08 22:46:33 · answer #1 · answered by Amit 2 · 0⤊ 0⤋
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.
2007-07-08 22:44:41 · answer #2 · answered by the king 2 · 0⤊ 0⤋
I'm going to try to put it in one line that is not a copy of Wiki passage:
RI dictates that if a tuple (record) having relationship/link to another tuple in any relation (table), a change in one should make any necessary updates to uphold that link so the link is valid in the context of its use.
2007-07-09 00:55:10 · answer #3 · answered by Andy T 7 · 0⤊ 0⤋