____ key must satisfy referential integrity in a relation, while ____ key must…
2018
____ key must satisfy referential integrity in a relation, while ____ key must satisfy entity integrity.
- A.
Candidate, primary
- B.
Foreign, primary
- C.
Primary, foreign
- D.
Foreign, super key
Attempted by 2200 students.
Show answer & explanation
Correct answer: B
A foreign key must satisfy referential integrity, which ensures that a value in one table must correspond to a valid primary key value in another table. A primary key must satisfy entity integrity, meaning it uniquely identifies each record in a table and cannot be null.
A video solution is available for this question — log in and enroll to watch it.