Question: what is the difference between primary key foreign key and candidate key?
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.