Question

State the relationship and difference between a primary and foreign key

Answer 1

Answer:

A primary key should have unique attribute values whereas, a foreign key may have duplicate attribute values. There may be multiple foreign keys in a relation, but a relation has only one primary key. The primary key constraint can be applied to the temporary tables.