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

  1. A.

    P only

  2. B.

    Q only

  3. C.

    Both P and Q

  4. 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.

Explore the full course: Mppsc Assistant Professor