it is the attribute/column or a set of attributes/columns in a relation/table that qualifies for uniqueness of each tuple/row. A relation/table can have one or more than one Candidate Keys.
A Candidate key is also known as a minimal Super key.
StudID | Roll No | First Name | Last Name | |
---|---|---|---|---|
1 | 11 | Prayag | Verma | [email protected] |
2 | 12 | Rahul | Raz | [email protected] |
3 | 13 | Pankaj | Jacker | [email protected] |
4 | 14 | Mukesh | Mugu | [email protected] |
5 | 15 | Rakesh | Ravi | [email protected] |