The GATE Grind

GATE 2014 CS (CS2) – Question 31

Databases · Integrity Constraints and Normal Forms · 1 mark · Numerical answer

Find the maximum number of superkeys of R(E,F,G,H) with E as the key.

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: 8 to 8

Explanation

Every set containing E is a superkey. Each of the remaining F,G,H may independently be included or omitted, giving2³=**8**. The intended statement takes E as the only candidate key; allowing additional keys can increase the total beyond8.