Question: what is the difference between a primary key and a foreign key in a relational database?
Answer: A primary key is used to ensure data in the specific column is unique. A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It uniquely identifies a record in the relational database table. ... Only one primary key is allowed in a table.