Discussion :: DBMS MCQs
- 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 View Answer
|
Whatsapp
Facebook
Answer : Option B
Explanation :
2 NF and hence also in 1 NF
The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.
Be The First To Comment