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 … Read more