Which type of integrity preserves the defined relationship between tables when records are entered or deleted?

Options
- Entity integrity
- Domain integrity
- Referential integrity
- User-defined integrity


CORRECT ANSWER : Referential integrity

Discussion Board
Referential integrity

Referential integrity is a relational database concept, which states that table relationships must always be consistent. Referential integrity means that the foreign key in any referencing table must always refer to a valid row in the referenced table. Referential integrity ensures that the relationship between two tables remains synchronized during updates and deletes.

Prajakta Pandit 03-7-2017 04:14 AM

Referential integrity

Referential integrity is a property of data which, when satisfied, requires every value of one attribute (column) of a relation (table) to exist as a value of another attribute in a different (or the same) relation (table).

Arulraj 12-19-2014 08:20 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement