State the similarities and differences between …

<th>Primary Key</th> <th>Candidate Key</th> <th>Primary key is a minimal super key. So there is one and only one primary key in a relation.</th> <th>While in a relation there can be more than one candidate key.</th> <th>Any attribute of Primary key can not contain NULL value.</th> <th>While in Candidate key any attribute can contain NULL value.</th> <th>Primary key can be optional to specify any relation.</th> <th>But without candidate key there can’t be specified any relation.</th> <th>Primary key specifies the important attribute for the relation.</th> <th>Candidate specifies the key which can qualify for primary key.</th> <th>Its confirmed that a primary key is a candidate key.</th> <th>But Its not confirmed that a candidate key can be a primary key.</th>

S.NO

1.

2.

3.

4.

5.

<pre> |-------------------------------------|---------------------------------| |**alternate key** |**foreign key** | |-------------------------------------|---------------------------------| |unique |non-unique | |-------------------------------------|---------------------------------| |never accept null value |accept null value | |-------------------------------------|---------------------------------| |can be multiple |can be multiple | |-------------------------------------|---------------------------------| |Independent another table |Dependent another table | |-------------------------------------|---------------------------------| |Create Noncluster index automatically|Cannot create index automatically| |-------------------------------------|---------------------------------|</pre>