Write the difference between primary key and alternate key

1.	Write the difference between primary key and alternate key
Answer» Primary key is a Candidate key chosen to uniquely identify tuples in the table. Primary key values should be unique and non-null. Alternate keys are those Candidate keys that were not chosen to be the Primary key of the table. Composite key is a Candidate key that consists of more than one attribute.

Discussion