A relation is in 5NF when multivalued dependencies are isolated in their own relation.
A. True
B. False
Answer: Option A
Solution (By Examveda Team)
Option1: True- In the relational model, a relation is said to be in 5NF (Fifth Normal Form) when multivalued dependencies are isolated in their own relation.
- This means that each multivalued dependency is represented by a separate relation, ensuring data integrity and reducing redundancy.
Option2: False
- If a relation is not in 5NF, it means that multivalued dependencies are not isolated in their own relation.
- This can lead to data anomalies and inconsistencies in the database.
Conclusion:
Based on the explanation provided, the correct option is Option1: True. A relation is in 5NF when multivalued dependencies are isolated in their own relation to ensure data integrity and reduce redundancy in the database.
Join The Discussion