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 ?
Submit Solution