For referential integrity to hold, any field in a table that is declared a super key can contain only values from a parent table's primary key or a candidate key.

Options
- False
- True


CORRECT ANSWER : False

Discussion Board
Referential integrity

The above statement is false. 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 (column) in a different (or the same) relation (table). For referential integrity to hold in a relational database, any column in a base table that is declared a foreign key can contain either a null value, or only values from a parent table's primary key or a candidate key. For instance, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity.

Prajakta Pandit 02-9-2017 04:37 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