When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
(a) Transitive Dependency
(b) Insertion Anomaly
(c) Referential Integrity Constraint
(d) Normal Form
I had been asked this question during an interview.
This intriguing question comes from Normalization in portion Planning Oracle Applications of Oracle