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

Question #75641

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

Expert's answer

a Foreign Key