Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | Gate IT 2005 | Question 22

  • Difficulty Level : Basic
  • Last Updated : 28 Jun, 2021

A table has fields Fl, F2, F3, F4, F5 with the following functional dependencies  
F1 → F3   F2→ F4   (F1 . F2) → F5
In terms of Normalization, this table is in

(A) 1 NF
(B) 2 NF
(C) 3 NF
(D) none

Answer: (A)


Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

First Normal Form
A relation is in first normal form if every attribute in that relation is singled valued attribute.

Second Normal Form

A relation is in 2NF iff it has No Partial Dependency, i.e., no non-prime attribute (attributes which are not part of any candidate key) is dependent on any proper subset of any candidate key of the table.

This table has Partial Dependency f1->f3, f2-> f4 given (F1,F2) is Key

So answer is A

Quiz of this Question
Please comment below if you find anything wrong in the above post

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!