__________ constraints ensure that a value that appears in one relation for a…
2013
__________ constraints ensure that a value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation.
- A.
Logical Integrity
- B.
Referential Integrity
- C.
Domain Integrity
- D.
Data Integrity
Attempted by 320 students.
Show answer & explanation
Correct answer: B
Referential Integrity constraints ensure that a value appearing in one relation for a given set of attributes also appears in another relation. This mechanism maintains consistency between tables by requiring that foreign key values match primary key values in the related table.
A video solution is available for this question — log in and enroll to watch it.