What Is The Difference Between Candidate Key And Super Key?


2 Answers

Anonymous Profile
Anonymous answered
In order to make the data access powerfull , we can have candidate key and super key.

Superkey is one which has combination of unique keys to identify the records.
Candidate key is a part of superkey
for eg:  If super key has three attributes
two of those key can be called or used as candidate key
candidate key is minimal of super key
so candidate key can also be called as a nominees of superkey
Rajat Khosla Profile
Rajat Khosla answered

Super Key: An attribute or set of attributes that uniquely identifies a tuple within a  relation

Candidate key: A super key such that no proper subset is a super key within the relation

Answer Question