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: Option C
Solution(By Examveda Team)
A referential integrity constraint is defined as part of an association between two entity types. The definition for a referential integrity constraint specifies the following information: The principal end of the constraint. (An entity type whose entity key is referenced by the dependent end.)This Question Belongs to Database >> The Relational Model And Normalization
Join The Discussion
Comments ( 1 )
Related Questions on The Relational Model and Normalization
A. A → B.
B. A → C.
C. A → (B,C).
D. (B,C) → A.
A. normal forms.
B. referential integrity constraints.
C. functional dependencies.
D. None of the above is correct.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
A. second normal form.
B. third normal form.
C. fourth normal form.
D. domain/key normal form.
explain referential integrity constraint?