In relational database management, which of the following is/are…
2019
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
Attempted by 301 students.
Show answer & explanation
Correct answer: C
A candidate key in a relational database must satisfy two essential properties. First, it requires uniqueness to ensure no two tuples share the same key values. Second, it demands irreducibility or minimality, meaning no proper subset can uniquely identify tuples. Therefore, both P and Q are correct properties of a candidate key.