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 _____.
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…
Attempted by 845 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.
Loading lesson…