UGC-NET | NTA UGC NET 2019 June – II | Question 32
In relational database management, which of the following is/are property/properties of candidate key?
(A) P only
(B) Q only
(C) Both P and Q
(D) Neither P nor Q
A candidate key have both property:
1. Uniqueness: in each tuple of R, values of K uniquely identify that tuple.
2. Irreducibility: no proper subset of K has the uniqueness property.
A Super key with no proper subset that uniquely identifies a tuple of relation(uniqueness + irreducibility).
Quiz of this Question
Please comment below if you find anything wrong in the above post