Answer to Question #75641 in Databases | SQL | Oracle | MS Access for Jonny

Question

Referential integrity refers to maintaining consistency of values about the same attribute across relations. For instance, in a database that has a State relation with a state_code column for the two-character state codes, there cannot be another relation referencing that State relation with state_code values other than the ones in the State relation.

What component of the Relational Model would enforce such referential integrity?


a Foreign Key


a Primary Key


a Relation


Index

Answer 1

a Foreign Key