What is a Primary Key vs Foreign Key?

What is a Primary Key vs Foreign Key?

Approach: Define internal vs external references.

A Primary Key uniquely identifies a record in its own table. A Foreign Key is a field in one table that links to the Primary Key of another table to establish a relationship.

Follow-up: Can a Foreign Key be NULL?

Key concepts: unique identifier, referential integrity.