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
Answer:A
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
Explanation: Referential Integrity is set of constraints applied to foreign key which prevents entering a row in child table for which you don’t have any corresponding row in parent table i.e. entering NULL or invalid foreign keys.