Which of the following statement is correct, according to the following instance of the relational schema R(X, Y, Z)?

X Y Z
1 1 a
1 1 a
2 1 b
3 2 b

This question was previously asked in
UGC NET Computer Science (Paper 2) 11 March 2023 Official Paper
View all UGC NET Papers >
  1. X →Y, Z → X
  2. Y → Z, Z → X
  3. X → Y, X → Z 
  4. Y → X, X → Z

Answer (Detailed Solution Below)

Option 3 : X → Y, X → Z 
Free
UGC NET Paper 1: Held on 21st August 2024 Shift 1
8.7 K Users
50 Questions 100 Marks 60 Mins

Detailed Solution

Download Solution PDF

The correct answer is X → Y, X → Z 

Key PointsA functional dependency, denoted X → Y, refers to a relationship between two sets of attributes. If X → Y, this means that for all tuples in a relation, if two tuples have the same value for the set of attributes X, they must also have the same value for the set of attributes Y. Similarly, for Y → X, if two tuples have the same Y value, they must have the same X value.

X Y Z
1 1 a
1 1 a
2 1 b
3 2 b

Let's analyze the four options:

  • X → Y, Z → X:  X is functionally dependent on Y because it is uniquely identify Y value but Z does not hold true because Z is not functionally dependent on X. so it is incorrect .
  • Y → Z, Z → X: Y does not determine Z uniquely so it is also incorrect.
  • X → Y, X → Z: X is functionally dependent on Y because it is uniquely identify Y value and X is functionally dependent on Z because it is uniquely identify Z value. So, both functional dependency are correct.
  • Y → X, X → Z: Y does not determine X uniquely so it is also incorrect.

So, Correct answer is X → Y, X → Z

Latest UGC NET Updates

Last updated on Jun 6, 2025

-> The UGC NET Exam Schedule 2025 for June has been released on its official website.

-> The UGC NET Application Correction Window 2025 is available from 14th May to 15th May 2025.

-> The UGC NET 2025 online application form submission closed on 12th May 2025.

-> The June 2025 Exam will be conducted from 21st June to 30th June 2025

-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.

-> The exam is conducted bi-annually - in June and December cycles.

-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions. 

-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.

More Functional Dependency Questions

More Integrity Constraints and Normal Form Questions

Get Free Access Now
Hot Links: teen patti real cash withdrawal teen patti master official teen patti real cash apk teen patti gold new version 2024 teen patti master download