If AB and C are the candidate keys in a relation schema R(A,B,C,D), then what…
2018
If AB and C are the candidate keys in a relation schema R(A,B,C,D), then what are the prime attributes?
- A.
A, B, and C only
- B.
A and B only
- C.
A and C only
- D.
B and C only
Attempted by 433 students.
Show answer & explanation
Correct answer: A
Prime attributes are defined as any attribute that is part of at least one candidate key. Since the candidate keys are AB and C, the attributes A, B, and C constitute the set of prime attributes.