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

All the minimal super key with no redundant attributes is known as candidate key.

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 only two set of attribute can declarred as candidate key out of the six super keys, because other four keys have redundant attributes that are not necessary for unique identification

  • {Emp_SSN}
  • {Emp_Number}

Therefore, these two sets of attributes are candidate keys among the all other sets.

softetechnologies

Note
All the candidate keys are super keys, but not vice versa. Because candidate keys are the sub set of super keys.

Super key - RDBMS Primary 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.
Rabindranath Tagore
Every child comes with the message that God is not yet discouraged of man.
Rabindranath Tagore
2909
81.09
Today So Far
Total View (Lakh)
softetechnologies
26/05/2018     54173
25/06/2018     45158
01/01/2018     43708
28/06/2017     41235
02/08/2017     40259
01/08/2017     34302
06/07/2017     34096
15/05/2017     33353
11/09/2018     30370
14/07/2017     29870
softetechnologies