Question

Explain the distinctions among the terms primary key, candidate key, and super key.

Answer 1

If K is a superkey, then so is any superset of K. A superkey for which no proper subset is also a superkey is called a candidate key. It is possible that several distinct sets of attributes could serve as candidate keys.