×
FREE ASSISTANCE FOR THE INQUISITIVE PEOPLE
Tutorial Topics
X
softetechnologies
CREATE TABLE - Structured Query Language Candidate key - RDBMS
Super key - RDBMS - SQL
568    Arnab De    21/11/2021

Super key

A set or collection of one or more attributes or fields (column), which uniquely identify a row or tuple in a relation or table is known as super 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

The above table has many super key s and those super keys are able to uniquely identify a tuple of the employee table.

  • {Emp_No}
  • {Emp_SSN}
  • {Emp_SSN, Emp_Name}
  • {Emp_SSN, Emp_No}
  • {Emp_No, Emp_Name}
  • {Emp_SSN, Emp_No, Emp_Name}
softetechnologies
CREATE TABLE - Structured Query Language Candidate 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.
Mahatma Gandhi
By education, I mean all-around drawing of the best in child and man in body, mind and sprit.
Mahatma Gandhi
2332
40.89
Today So Far
Total View (Lakh)
softetechnologies
01/01/2018     34530
26/05/2018     32712
28/06/2017     31333
02/08/2017     29638
25/06/2018     27459
15/05/2017     24905
01/08/2017     24105
06/07/2017     23630
21/04/2018     19451
14/07/2017     19139
softetechnologies