Question: what is the difference between primary key and foreign key with example?
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.