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.
Answer: Option C
Solution (By Examveda Team)
Option1: second normal form.In the second normal form, all attributes must depend on the entire primary key. This means that there should be no partial dependencies in the relation. However, being in the second normal form does not guarantee the absence of multivalued dependencies.
Option2: third normal form.
In the third normal form, all attributes must depend only on the primary key and not on any other non-prime attributes. While being in the third normal form helps in reducing redundancy and improving data integrity, it does not necessarily eliminate multivalued dependencies.
Option3: fourth normal form.
In the fourth normal form, a relation is in BCNF and has no multivalued dependencies. This means that all non-trivial functional dependencies are on superkeys. Therefore, a relation in BCNF with no multivalued dependencies is in the fourth normal form.
Option4: domain/key normal form.
The domain/key normal form is not a standard normal form in the relational model. It is used to ensure that all attributes are atomic and that there are no repeating groups. While it helps in organizing data, it does not specifically address multivalued dependencies.
Conclusion: The correct option is fourth normal form. This is because a relation in BCNF with no multivalued dependencies is considered to be in the fourth normal form.
Join The Discussion