Official PYQ · 2016Set 1 · Q21Normal FormsMCQ1 mark

GATE CS 2016 Set 1 Q21 — Normal Forms

Which of the following is NOT a superkey in a relational schema with attributes $V,W,X,Y,Z$ and primary key $V\;Y$ ?

View worked solution

Answer: B

A superkey is a set of attributes that contains a candidate key (or primary key) as a subset. For any set of attributes to be a superkey in this schema, it must contain the primary key $VY$ .

Let's analyze the given options:

Option A ( $VXYZ$ ): Contains both $V$ and $Y$ . Hence, it is a superkey.
Option B ( $VWXZ$ ): Does not contain $Y$ . Hence, it cannot be a superkey.
Option C ( $VWXY$ ): Contains both $V$ and $Y$ . Hence, it is a superkey.
Option D ( $VWXYZ$ ): Contains both $V$ and $Y$ . Hence, it is a superkey.

Therefore, $VWXZ$ is not a superkey.

Free practice · Your answers on this page are not saved.

Published 10 Oct 2026

Report a correction

GATE CS · 2026Normal Forms
Let $P, Q, R$ and $S$ be the attributes of a relation in a relational schema. Let $X \rightarrow Y$ indicate functional dependency in the context of a relational database, where $X, Y \subseteq\{P, Q, R, S\}$ . Which of the following options is/are always true?
MSQ · 1 mark
GATE CS · 2026Normal Forms
In the context of relational database normalization, which of the following statements is/are true?
MSQ · 1 mark
GATE CS · 2026Normal Forms
In the context of schema normalization in relational DBMS, consider a set $\text{F}$ of functional dependencies. The set of all functional dependencies implied by $\text{F}$ is called the closure of $\text{F}$ . To compute the closure of $\text{F}$ , Armstrong's Axioms can be applied. Consider $X, Y$ , and $Z$ as sets of attributes over a relational …
MCQ · 2 marks
GATE CS · 2025Normal Forms
Consider a relational schema team $\text{(name,city,owner)}$ , with functional dependencies $\{\text{name} \rightarrow \text{city}, \text{name} \rightarrow \text{owner} \}$ . The relation team is decomposed into two relations, $\text{t1(name,city)}$ and $\text{t2(name, owner)}$ . Which of the following statement(s) is/are TRUE?
MSQ · 2 marks
GATE CS · 2025Normal Forms
Consider the following relational schema along with all the functional dependencies that hold on them. $\begin{array}{l} R 1(A, B, C, D, E):\{D \rightarrow E, E A \rightarrow B, E B \rightarrow C\} \\ R 2(A, B, C, D):\{A \rightarrow D, A \rightarrow B, C \rightarrow A\} \end{array}$ Which of the following statement(s) is/are TRUE?
MSQ · 2 marks
GATE CS · 2024Normal Forms
Which of the following statements about a relation $\mathbf{R}$ in first normal form $\text{(1NF)}$ is/are TRUE?
MSQ · 1 mark

Browse this topic

More Normal Forms questions

GATE CS 2016 Set 1 Q21 — Normal Forms

Related questions