Database Analyst Interview Question:

Tell me what are the differences between primary and foreign keys?

Submitted by: Muhammad

The primary key is the column or set of columns used to uniquely identify the items in a table. A foreign key is used to uniquely identify the items in a different table, allowing join operations to happen.
Submitted by: Muhammad