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

1
1 NF only
2
2 NF and hence also in 1 NF
3
3NF and hence also in 2NF and 1NF
4
BCNF and hence also in 3NF, 2NF and 1NF

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation