Question

Differentiate between Primary key and foreign key.

Answer 1

Primary Key: Primary key is a column or group of columns in a table that uniquely identify the records in the table.

Foreign Key: Foreign keys are the columns of the table which refer to the primary key of another table. A foreign key creates a relationship between two tables.