Why are Candidate Keys?


A candidate key always expresses a business rule of uniqueness:

  • Every state has a unique state code for mailing.
  • A table or entity with no candidate key is probably not normalized. and almost certainly not useful in an information system.



    Copyright © 1996 Applied Information Science International