A relation Empdtl is defined with attributes empcode (unique), name, street,…
GATE · 2004 · IT
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
- A.
1NF only
- B.
2NF and hence also in 1NF
- C.
3NF and hence also in 2NF and 1NF
- D.
BCNF and hence also in 3NF, 2NF an 1NF
Attempted by 280 students.
Sign up free to check your answer
Sign up freeLoading lesson…