What distinction between Super and Candidate type in ERDB?

Thanks.

candidate secret is a minimal superkey

A superkey is some posts that distinctively identifies a row. An Applicant key will be a MINIMAL group of posts that distinctively identifies a row. So basically a Superkey is really a Candidate key with extra unnecessary posts inside it.

  • Candidate key = minimal answer to identify a row
  • Super key = a minimum of as wide like a candidate key

For me personally, an excellent key would certainly introduce ambiguities on the candidate key