Open In App

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

Like Article
Like
Save
Share
Report

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


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads