Skip to content
Related Articles

Related Articles

Improve Article
GATE | GATE-IT-2004 | Question 75
  • Difficulty Level : Hard
  • Last Updated : 16 Dec, 2015

A relation Empdtl is defined with attributes empcode (unique), name, street, city, state and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms, Empdtl is a relation in
(A) 1NF only
(B) 2NF and hence also in 1NF
(C) 3NF and hence also in 2NF and 1NF
(D) BCNF and hence also in 3NF, 2NF an 1NF


Answer: (B)

Explanation:  

Given:

Empdtl: empcode , name, street, city, state and pincode

  • There is transitive dependency in Table ( pincode, there is only one city and state),so not in 3NF
  • All attributes are fully dependant on key,so in 2NF

So answer is B

 

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

Attention reader! Don’t stop learning now. Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :