Discussion Forum : Normal Forms
Question -
Empdt1(empcode, name, street, city, state,pincode).
For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
Answer: Option B
Was this answer helpful ?
2 NF and hence also in 1 NFThe relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.
Was this answer helpful ?
Login With Google
Old way of Login
Login With Email
Submit Your Solution hear: