Aspire's Library
A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations - NIMCET
Study Stuff for MCA Examinations - NIMCET
Previous Year Question (PYQs)
Which of the following relations cannot be decomposed into BCNF with a lossless join and dependency-preserving decomposition?
R(V, W, X, Y, Z)
Solution
BCNF condition:
For every functional dependency $X \rightarrow Y$, X must be a superkey.
Check option (3)
FDs:
$VW \rightarrow X$
$X \rightarrow YV$
Here:
$X$ determines $V$ and $Y$
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
Ask Your Question or Put Your Review.
