Q: 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

A 1 NF only
B 2 NF and hence also in 1 NF
C 3NF and hence also in 2NF and 1NF
D BCNF and hence also in 3NF, 2NF and 1NF
Share this MCQ

Learn More MCQ Questions from DataBase Management System Normal Form MCQ

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.

Q: 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

Report Question

Q: 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