Question: what is the difference between foreign key and candidate key?
Answer: Foreign Key: FK is a key in one table (child) that uniquely identifies a row of another table (parent). A FK is not-unique in the child table. ... Candidate Key: A candidate key can be uniquely used to identify a database record without any extraneous data. They are Not Null and unique.