what is super key in dbms with example

Example: super key in dbms with example

A superkey is a set of attributes within a table whose values can be used to uniquely identify a tuple. ... We only need, per our example, the set {employeeID}. This is a minimal superkey—that is, a minimal set of attributes that can be used to identify a single tuple. employeeID is a candidate key.