• Multiple attributes in a Super Key may not be able to independently identify tuples in a table, but when combined with particular keys, they can uniquely identify tuples.
• Super keys can have redundant properties that aren't necessary for tuple identification.
• A candidate keyis a single or a collection of keys that uniquely identify rows in a database.
• A Candidate key is a subset of Super keys that is devoid of all non-essential properties for uniquely identifying tuples.
• Super keys are a subset of Candidate keys. They only have the attributes that are required to identify tuples uniquely.
• Super keys are used for all Candidate keys. However, the opposite is not true.

Read More: How to create a simple query in MS Access?