Question

What are the difference between Primary Key, Candidate key and Foreign Key?
​

Answer 1

Answer:

Primary Key - is a column or group of columns in a table that uniquely identify every row in that table. Candidate Key - is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes. ... Foreign Key - is a column that creates a relationship between two tables.

Hoe it helps ❤❤

Answer 2

Explanation:

Primary Key - is a column or group of columns in a table that uniquely identify every row in that table. Candidate Key - is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes. ... Foreign Key - is a column that creates a relationship between two tables.