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
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