What is Candidate Key ? Short note on Candidate Key.
Candidate Key :-
A candidate key is a minimum super-key that is superkies for which proper subset is a superkey.
For example, suppose that a combination of CUST-NAME and ADDR is sufficient to distinguish among members of the customer entity set. Both {CUST-NO} and {CUST-NAME, ADDR } are candidate keys. Although the attributes CUST-NO and CUST-NAME together can distinguish customer entities but there combination does not form a candidate key, since the attributes CUST-NO alone is a candidate key.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment