Open In App

GATE | GATE-CS-2014-(Set-2) | Question 31

The maximum number of superkeys for the relation schema R(E,F,G,H) with E as the key is
(A) 5
(B) 6
(C) 7
(D) 8

Answer: (D)
Explanation: Maximum no. of possible superkeys for a table with n attributes = 2^(n-1)
Here, n = 4.
So, the possible superkeys = 24-1 = 8
The possible superkeys are : E, EH, EG, EF, EGH, EFH, EFG, EFGH
Quiz of this Question

Article Tags :