Question: what is the difference between a candidate key and a secondary key?
Answer: Secondary key is a non-unique field. One secondary key value may refer to many records. Candidate Key or Alternate key A relation can have only one primary key. It may contain many fields or combination of fields that can be used as primary key.