The Relational Model and Normalization

Q1: 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.

ANS:C - referential integrity constraint.

Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table.



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.