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?
P: Uniqueness
Q: Irreducibility
(A) P only
(B) Q only
(C) Both P and Q
(D) Neither P nor Q


Answer: (C)

Explanation:
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

My Personal Notes arrow_drop_up

Save