What distinction between Super and Candidate type in ERDB?
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