Consider a relation R with attributes (A, B, C), where B is the only candidate…
2024
Consider a relation R with attributes (A, B, C), where B is the only candidate key. Identify the total number of possible super keys of the relation R.
- A.
1
- B.
3
- C.
4
- D.
2
- E.
Question not attempted
Attempted by 1578 students.
Show answer & explanation
Correct answer: C
Step 1: A super key is a set of attributes that can uniquely identify a tuple in a relation. Step 2: Since B is the only candidate key, any super key must include B. Step 3: The other attributes A and C can be included or excluded independently, giving 2 choices for A and 2 choices for C. Step 4: Total number of super keys = 2^2 = 4.