What type of key constraint ensures that values in a column must match existing values in a primary key column of another table?
Subject: Database Systems
Topic: Database Normalization
Options:
- Option A: Primary Key
- Option B: Foreign Key
- Option C: Unique Key
- Option D: Super Key
Correct Answer:
Option B: Foreign Key
Explanation:
A Foreign Key constraint enforces referential integrity by linking a column in a child table to a primary or unique key column in a parent table.