what is the difference between primary key and foreign key in dbms?
Relation of Primary Key vs Foreign Key A primary key uniquely identifies a record in the relational database table, whereas a foreign key refers to the field in a table which is the primary key of another table.