Empdt1(empcode, name, street, city, state,pincode).<br> 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

Normal Form MCQ - General Knowledge Question and Answer

Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables into smaller tables and links them using relationships.

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 NF only
2 NF and hence also in 1 NF
3NF and hence also in 2NF and 1NF
BCNF and hence also in 3NF, 2NF and 1NF

Answer:

The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.

Share Me: