Skip to content
Official PYQ · 1987

GATE CS 1987 Q2n — Normal Forms

Explain with AI
State whether the following statements are TRUE or FALSE:

A relation rr with schema (X,Y)(X, Y) satisfies the function dependency X→YX \rightarrow Y, The tuples ⟨1,2⟩\langle 1, 2\rangle and ⟨2,2⟩\langle 2, 2 \rangle can both be in rr simultaneously.
View worked solution

Answer: 1

A functional dependency X→YX \rightarrow Y holds on a relation rr if and only if for any two tuples t1,t2∈rt_1, t_2 \in r, whenever t1[X]=t2[X]t_1[X] = t_2[X], it must also be that t1[Y]=t2[Y]t_1[Y] = t_2[Y].

For the given tuples t1=⟨1,2⟩t_1 = \langle 1, 2 \rangle and t2=⟨2,2⟩t_2 = \langle 2, 2 \rangle:

  • t1[X]=1t_1[X] = 1 and t2[X]=2t_2[X] = 2.
  • Since t1[X]≠t2[X]t_1[X] \neq t_2[X], the condition for the functional dependency is vacuously satisfied.

Therefore, both tuples can coexist in rr simultaneously without violating X→YX \rightarrow Y. The statement is TRUE (represented by 1).

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

Published
Report a correction
Keep exploringMore Normal Forms questions