Question

A relation Empdtl is defined with attributes empcode (unique), name, street, city, state and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms, Empdtl is a relation in:

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

Answer 1

Correct Answer - Option 2 : 2 NF and hence also in 1 NF

Given that FD:

1) Pin code →  city, state

2) Street, city, state →  pin code

The candidate keys of relation is empcode as it uniquely identifies the relation.

Hence, it is in 2NF and therefore, also in 1NF.