Question: what is the relationship and difference between primary key and foreign key?
Answer: A primary key acts as a unique identifier for each record meaning it uniquely identifies each row/record in a table. "A foreign key" is a field in one table that relates the tables together.