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
Answer:A
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
Explanation: The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key. Sanfoundry Global Education & Learning Series – Database Management System.