×
FREE ASSISTANCE FOR THE INQUISITIVE PEOPLE
Tutorial Topics
X
softetechnologies
CREATE TABLE - Structured Query Language Candidate key - RDBMS
Super key - RDBMS - SQL
918    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.
Sri Sri Ramakrishna Paramahamsa
All religions are true. God can be reached by different religions. Many rivers flow by many ways but they fall into the sea. They all are one.
Sri Sri Ramakrishna Paramahamsa
576
50.7
Today So Far
Total View (Lakh)
softetechnologies
26/05/2018     41364
01/01/2018     35770
28/06/2017     33774
25/06/2018     32831
02/08/2017     32142
06/07/2017     26594
01/08/2017     26559
15/05/2017     26214
14/07/2017     21527
21/04/2018     20512
softetechnologies