Sail E0 Webinar
Question
Empdt1(empcode, name, street, city, state,pincode).
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
Options:
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 View Answer
Answer: Option B


2 NF and hence also in 1 NFThe relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers