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

My Personal Notes arrow_drop_up

Recommended Posts:

0 Average Difficulty : 0/5.0
No votes yet.

User Actions