Q. Differentiate between primary key and candidate key in a relation.
Answer =
Answer =
Candidate key: A candidate key is the one that is capable of becoming primary key i.e., a field or attribute that has unique value for each row in the relation.
Primary key: is a designated attribute or a group of attributes whose values can uniquely identify the tuples in the relation.
Primary key: is a designated attribute or a group of attributes whose values can uniquely identify the tuples in the relation.
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )