What is the difference between a primary key and a foreign key in a relational database management system (DBMS)?

1 Answers
Answered by suresh

Difference between Primary Key and Foreign Key in DBMS

Difference between Primary Key and Foreign Key in DBMS

In a relational database management system (DBMS), a primary key is a unique identifier for each record in a table. It ensures that each record is uniquely identifiable and helps in maintaining data integrity. On the other hand, a foreign key is a field in a table that is related to the primary key of another table. It establishes a link between two tables and enforces referential integrity.

While a primary key is used to uniquely identify records within a table, a foreign key establishes relationships between tables by referencing the primary key of another table. In simple terms, the primary key is like a unique identification card for each record, whereas the foreign key is like a reference to another record's unique identification card.

Understanding the difference between a primary key and a foreign key is essential in designing a relational database structure and ensuring data consistency and integrity.

Answer for Question: What is the difference between a primary key and a foreign key in a relational database management system (DBMS)?