Question

what is the relationship and difference between primary key and foreign key

Answer 1

Primary Key is a chosen candidate key that uniquely defines a tuple in a relation. Foreign key in a table refers to the primary key of other table. No two tuples in a relation carry duplicate values for a primary key attribute. Tuples can carry duplicate value for a foreign key attribute

Answer 2

primary key is that the key used in our country whereas foreign key is the key used in usa