Question

Explain the difference between a primary key, foreign key and candidate key.

☆{FULLY EXPLAINED}​

Answer 1

Answer:

Difference Between Primary key & Foreign key

Helps you to uniquely identify a record in the table. ... Primary Key never accept null values. A foreign key may accept multiple null values. Primary key is a clustered index and data in the DBMS table are physically organized in the sequence of the clustered index

Answer 2

Answer:

Explanation:

candidate key is a key that uniquely identifies rows

primary key is a candidate key that uniquely identifies set of columns in a table

for example - s.r no in student table

foreign key is primary key of parent table and candidate key of child table

for example roll no