GATE CS 2024 Set 1 — Question 44

MSQ+2 / -0EasyFunctional DependenciesNormalizationDatabasesArmstrong's Axioms

Databases → Normalization → Armstrong's Axioms

Last updated

Question

The symbol \rightarrow indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
A.
(X,Y)(Z,W)(X, Y) \rightarrow (Z, W) implies X(Z,W)X \rightarrow (Z, W)
B.
(X,Y)(Z,W)(X, Y) \rightarrow (Z, W) implies (X,Y)Z(X, Y) \rightarrow Z
C.
((X,Y)Z and WY)((X, Y) \rightarrow Z \text{ and } W \rightarrow Y) implies (X,W)Z(X, W) \rightarrow Z
D.
(XY and YZ)(X \rightarrow Y \text{ and } Y \rightarrow Z) implies X → Z

Correct answer

(B) (X, Y) arrow (Z, W) implies (X, Y) arrow Z; (C) ((X, Y) arrow Z and W arrow Y) implies (X, W) arrow Z; (D) (X arrow Y and Y arrow Z) implies X arrow Z

Solution

We evaluate each option based on Armstrong's Axioms and derived rules for functional dependencies:
(A) (X,Y)(Z,W)(X, Y) \rightarrow (Z, W) implies X(Z,W)X \rightarrow (Z, W)
This is FALSE. We cannot simply remove attributes from the determinant (left side) of a functional dependency. For example, if XX is StudentName and YY is CourseID, together they might determine Grade (ZZ), but StudentName alone does not determine Grade.
(B) (X,Y)(Z,W)(X, Y) \rightarrow (Z, W) implies (X,Y)Z(X, Y) \rightarrow Z
This is TRUE by the Decomposition Rule. If a set of attributes determines a set of attributes, it determines any subset of those attributes.
(C) ((X,Y)Z and WY)((X, Y) \rightarrow Z \text{ and } W \rightarrow Y) implies (X,W)Z(X, W) \rightarrow Z
This is TRUE by the Pseudotransitivity Rule.
Proof:
1.W → Y (Given)
2.XW → XY (Augmentation of 1 with XX)
3.XY → Z (Given)
4.XW → Z (Transitivity on 2 and 3)
(D) (XY and YZ)(X \rightarrow Y \text{ and } Y \rightarrow Z) implies X → Z
This is TRUE by the Transitivity Rule (one of Armstrong's Axioms).
Therefore, options (B), (C), and (D) are correct.

More questions on Normalization

Practice GATE CS PYQs with adaptive difficulty

Timed practice, skill tracking, and AI explanations — free to start.

Start practicing free