Skip to content
Related Articles

Related Articles

GATE | GATE-CS-2002 | Question 50
  • Last Updated : 30 Nov, 2014

From the following instance of a relation scheme R (A, B, C), we can conclude that :

ABC
111
110
232
232

(A) A functionally determines B and B function­ally determines C

(B) A functionally determines B and B does not functionally determine C
(C) B does not functionally determine C
(D) A does not functionally determine B and B does not functionally determine C


Answer: (C)

Explanation: Generally Normalization is done on the schema itself.

From the relational instance given,we may strike out FD s that do not hold.

e.g.B does not functionally determine C(This is true).



But we cannot say that A functionally determines B for the entire relation itself. This is because that, A->B holds for this instance, but in future there might be some tuples added to the instance that may violate A->B.

So overall on the relation we cannot conclude that A->B, from the relational instance which is just a subset of an entire relation.

Refer http://quiz.geeksforgeeks.org/database-normalization-introduction/ for more details.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :