The Relational Model and Normalization - Technical MCQs

Q1:

A relation is in this form if it is in BCNF and has no multivalued dependencies:

A second normal form.

B third normal form.

C fourth normal form.

D domain/key normal form.

ANS:C - fourth normal form.

1NF
It should only have single(atomic) valued attributes/columns.

2NF
It should be in the 1NF.And, it should not have Partial Dependency

3NF
It is in the 2NF. And, it doesn't have Transitive Dependency.

BCNF
It is in 3NF. and for every functional dependencyX->Y, X should be the super key of the table.

For 4NF
The realtionship must be in 3NF, and there will not be any multivalued dependancy.

5NFA
It is in 4NF and it cannot be decomposed into any number of smaller tables without loss of data