The maximum number of superkeys for the relation schema R(E,F,G,H) with E as…
2014
The maximum number of superkeys for the relation schema R(E,F,G,H) with E as the key is _____.
Attempted by 792 students.
Show answer & explanation
Correct answer: 8
Answer: 8
Explanation:
Since E is the key, every superkey must include attribute E.
The remaining attributes are F, G, and H. Each of these three can either be present or absent in a superkey.
Number of possible combinations = 2^3 = 8, so there are 8 possible superkeys (all sets that contain E).
A video solution is available for this question — log in and enroll to watch it.