Question

A generalization of the Boyce Codd Normal Form to relation schemes which includes the multivalued dependencies is called _________________.

• A. Second Normal Form
• B. Third Normal Form
• C. Fourth Normal Form
• D. Fifth Normal Form

Answer 1

The correct option is C Fourth Normal Form

A generalization of the Boyce Codd Normal Form to relation schemes which includes the multivalued dependencies is called Fourth normal form.

Boyce-Codd Normal Form (BCNF) is one of the forms of database normalization. A database table is in BCNF if and only if there are no non-trivial functional dependencies of attributes on anything other than a superset of a candidate key.

If no database table instance contains two or more, independent and multivalued data describing the relevant entity, then it is in 4^th Normal Form.