Question: what is the difference between an alternate key and a candidate key?
Answer: Candidate key: A column or a set of columns can be called as candidate key if they identify each row of a table uniquely. ... Alternate key: There can be more than one keys which can identify each row of the table uniquely. One of them is defined as primary key and rest of them is called alternate keys of the table.