Question

Q. 6. Differentiate between Candidate Key and Primary Key and Alternate
Key in context of RDBMS.​

Answer 1

Explanation:

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.

HERE IS YOUR ANSWER MATE