KPGCET-CSE-2019-74

Question

The multivalued dependencies (MVDs) can be eliminated using ______ normal form on _____ normal form relations.

• A. $1$st, $2$nd
• B. $2$nd, $3$rd
• C. $3$rd, BCNF
• D. $4$th, BCNF

Answer 1

option D is correct.

1NF---Atomicity (single value)

2NF-No partial dependency of Non prime attribute

3NF-No transitive dependency of non prime attribute

Answer 2

ANS : D The multivalued dependencies (MVDs) can be eliminated using _4TH NORMAL _____ normal form on _BCNF____ normal form relations.