Question: what is the difference between candidate key and alternate key?
Answer: Candidate Key - is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes. Alternate Key - is a column or group of columns in a table that uniquely identify every row in that table. Foreign Key - is a column that creates a relationship between two tables.