Difference between Primary Key and Foreign Key

Difference between Primary Key and Foreign Key

Difference between Primary Key and Foreign Key So the difference between Primary Key and Foreign Key is the most asked question of the interview. This is a very important concept. Before discussing the differences first we have to understand what is the primary key and foreign key. What is Primary Key: A primary key is … Read more

What is the candidate key in DBMS?

candidate_key

What is Candidate Key in DBMS? A Candidate Key in DBMS is a minimal set of columns/attributes that can be used to uniquely identify a single/every tuple or row in a relation. Candidate Keys are determined during database design based on the underlying business rules of the database. After finding all possible candidate keys in a relation.DBA choose … Read more