\t\t\tBasicThere can be only one primary key in any relation.There can be more than one candidate key in a relation.NULLNo attribute of a Primary key can contain NULL value.The attribute of a Candidate key can have NULL value.SpecifyIt is optional to specify a primary key for any relation.There can not be a relation without candidate key specified.FeaturePrimary key describes the most important attribute for the relation.Candidate keys present candidates that can qualify for Primary Key.Vice-VersaA primary key is a candidate key.But it not compulsory that each candidate key can be a primary key.\t
1.

What is the basic diffrence between primary and candidate key?

Answer» BASIS FOR COMPARISON PRIMARY KEY CANDIDATE KEY


Discussion

No Comment Found

Related InterviewSolutions