Foreign Keys in Database Fundamentals

Create Tables with Foreign Keys

Create two tables: Departments and Employees. Define a foreign key in Employees that references Departments. Insert sample data ensuring referential integrity.

Expected output: Two tables with a foreign key relationship and sample data inserted without errors.

Hint: Define Departments with a primary key and Employees with a foreign key referencing it.

A foreign key establishes a link between two tables by referencing the primary key of another table, enforcing referential integrity and ensuring consistent relationships.

Typically, a foreign key references a primary key or a unique key in another table to ensure uniqueness and integrity.

If cascading delete is enabled, related records are deleted automatically; otherwise, the database will prevent deletion to maintain referential integrity.