Teaching UGC NET Mock Test Series 2025 (Paper 1 & 2) DBMS Integrity Constraints and Normal Form Normal Form
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