×
FREE ASSISTANCE FOR THE INQUISITIVE PEOPLE
Tutorial Topics
X
softetechnologies
Candidate key - RDBMS Foreign key - RDBMS
Primary key - RDBMS - SQL
578    Arnab De    21/11/2021

Primary Keyis an unique attribute or set of unique attributes that can uniquely identify a tuple in a relation.

Primary key is auniqueandnot null attribute in a tuple. i.e. we cannot insert a tuple with blank or duplicate value in a primary key attribute.

Lets consider, a relation called emp

Emp
Emp_SSN Emp_No Emp_Name
1234544434 E-001 Pradipta Pal
5345232444 E-002 Abhijit Ganguly
4645673422 E-003 Suman Banerjee
softetechnologies

In the above relation called (Emp), Emp_SSN is a Primary Key. Here every Emp_SSN is unique and not null.

A Primary key is selected from a set of candidate keys. This is done by database admin or database designer. We can say that either {Emp_SSN} or {Emp_Number} can be chosen as a primary key for the table Employee.

softetechnologies
Candidate key - RDBMS Foreign key - RDBMS
softetechnologies
Author Details
Arnab De
I have over 16 years of experience working as an IT professional, ranging from teaching at my own institute to being a computer faculty at different leading institute across Kolkata. I also work as a web developer and designer, having worked for renowned companies and brand. Through tutorialathome, I wish to share my years of knowledge with the readers.
Enter New Comment
Comment History
No Comment Found Yet.
Albert Einstein
Imagination is everything. It is the preview of life's coming attractions.
Albert Einstein
1561
35.58
Today So Far
Total View (Lakh)
softetechnologies
01/01/2018     33880
28/06/2017     30126
26/05/2018     28037
02/08/2017     27820
15/05/2017     23768
25/06/2018     22412
06/07/2017     22314
01/08/2017     22297
21/04/2018     18818
14/07/2017     17248
softetechnologies