-
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
-
- zero
- more than zero but less than that of an equivalent 3NF decomposition
- proportional to the size of F
- indetermine
- zero
Correct Option: A
According to the problem, R is associated with functional dependencies, so this clearly indicates that relation R is in 3NF, i.e., third normal form. The property of 3NF says that there are few or no error are left and therefore, redundancy (arising out of functional dependencies) in resulting set of relations is negligible or 0 in most cases.
