NRM Q.1

Home
NRM Q.1

1A 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).

Forgot your password?

I agree with the Terms.