Question

Explain the concepts of Primary Key, Foreign Key, and Candidate Key.

Hint:

• {Candidate Key} – All possible attributes that can uniquely identify records.
• {Primary Key} – The candidate key selected to uniquely identify records.
• {Foreign Key} – A field that links one table to another table's primary key.

In short: \[ \text{Candidate Key} \rightarrow \text{Primary Key} \rightarrow \text{Foreign Key (link between tables)} \]

Answer 1