Question: what is relationship and difference between primary key and foreign key?
Answer: A primary key is a special key used to uniquely identify records in a table, whereas a foreign key is used to establish relationship between two tables. Both are identical in structure but play different roles in relational database schema.