GATE CS 2024 Set 1 — Question 44
MSQ+2 / -0EasyFunctional DependenciesNormalizationDatabasesArmstrong's Axioms
Databases → Normalization → Armstrong's Axioms
Last updated
Question
The symbol indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
A.
implies
B.
implies
C.
implies
D.
implies
X → ZCorrect 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) implies
This is FALSE. We cannot simply remove attributes from the determinant (left side) of a functional dependency. For example, if is StudentName and is CourseID, together they might determine Grade (), but StudentName alone does not determine Grade.(B) implies
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) implies
This is TRUE by the Pseudotransitivity Rule.
Proof:
This is TRUE by the Transitivity Rule (one of Armstrong's Axioms).Therefore, options (B), (C), and (D) are correct.
This is FALSE. We cannot simply remove attributes from the determinant (left side) of a functional dependency. For example, if is StudentName and is CourseID, together they might determine Grade (), but StudentName alone does not determine Grade.(B) implies
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) implies
This is TRUE by the Pseudotransitivity Rule.
Proof:
1.
W → Y (Given)2.
XW → XY (Augmentation of 1 with )3.
XY → Z (Given)4.
(D) implies XW → Z (Transitivity on 2 and 3)X → ZThis is TRUE by the Transitivity Rule (one of Armstrong's Axioms).Therefore, options (B), (C), and (D) are correct.
More questions on Normalization
2024 Set 2 Q19Once the DBMS informs the user that a transaction has been successfully completed, its effect…2024 Set 1 Q20Let S be the specification: "Instructors teach courses. Students register for courses. Courses are…2024 Set 2 Q20In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one…2024 Set 1 Q21In a tree, the requirement of at least half-full (50%) node occupancy is relaxed for which…2024 Set 1 Q22Which of the following statements about a relation in first normal form (1NF) is/are…
Practice GATE CS PYQs with adaptive difficulty
Timed practice, skill tracking, and AI explanations — free to start.
Start practicing free