A relation empdt1 is defined with attributes
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
| 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 |
Answer : B Explanation :
empdt1 {empcode, name, street, city, state, pincode) |
|
|
Option: A Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. |
