📝 Question
#1545
The relation EMPDT1 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 EMPDT1 is a relation in
✓
Correct Answer
B. 2NF and hence also in 1NF
💡
Explanation
Empcode is unique, therefore it is the primary key. Since the primary key consists of a single attribute there will be no partial dependency, hence the relation is in 2NF.
⌨️ Press
A
B
C
D
to select