Which key is specifically used to enforce referential integrity between two tables?Group of answer choicesComposite KeySuper KeyForeign KeyPrimary Key

To enforce referential integrity between two tables, the correct choice is:

Foreign Key

Explanation:

• Foreign Key: A foreign key in one table points to a primary key in another table, ensuring that the relationship between the two tables is consistent. This key is used to maintain the referential integrity of the data by allowing only values that are present in the primary key table.

• Composite Key: This consists of two or more columns that together uniquely identify a row in a table. It is not specifically used for enforcing referential integrity.

• Super Key: A super key is a set of one or more columns that can uniquely identify a row in a table. It is broader than the primary key and not specifically used for referential integrity.

• Primary Key: This uniquely identifies a record in its own table but does not enforce the integrity between two tables.

In conclusion, foreign keys are essential for maintaining the relationship and integrity of data across multiple tables in a database.