NRM Q.1

0. A relation empdt1 is defined with attributes
empdt1(empcode, name, street, city, state,Pincode).
For any Pincode, there is only one city and state.
Also, forgiven street, city, and state, there is just one Pincode.
In normalization terms, empdt1 is a relation in

  • Option : B
  • Explanation : empdt1 {empcode, name, street, city, state, pincode)
    Given functional dependency
    pincode -> (city) (state)
    (street) (city) (state) -->pincode
    This is in I NF and 2NF but not in 3NF because it contains transitive dependency.
    Hence the correct answer is (b).
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *