Question: what is the relationship and difference between primary 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. The primary key attributes cannot have NULL values however; a foreign key can have a NULL value.