Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

Question

TuteeHUB · Accepted Answer

Proportional to the size of F+

TuteeHUB · Answer

Zero

TuteeHUB · Answer

More than zero but less than that of an equivalent 3NF decomposition

TuteeHUB · Answer

Indeterminate

1.	Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
A.	Zero
B.	More than zero but less than that of an equivalent 3NF decomposition
C.	Proportional to the size of F+
D.	Indeterminate
Answer» C. Proportional to the size of F+

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

Discussion

No Comment Found

Related MCQs

Reply to Comment