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 1531 students.
Show answer & explanation
Correct answer: C
Answer: Both uniqueness and irreducibility.
Uniqueness: No two distinct tuples in the relation can have the same values for the candidate key attributes. For example, a student_id that uniquely identifies each student.
Irreducibility (minimality): No proper subset of the key's attributes can uniquely identify tuples. For example, if (course_id, student_id) together identify an enrollment, neither attribute alone identifies the enrollment, so the pair is minimal.
Why other choices are incorrect: Uniqueness without minimality may describe a superkey that has unnecessary attributes; minimality without uniqueness cannot identify tuples. Therefore a candidate key requires both properties.
A video solution is available for this question — log in and enroll to watch it.