Software-Engineering
October 7, 2023Reading-Comprehension
October 7, 2023Normalization
| Question 11 |
Relation R is decomposed using a set of functional dependencies, F, and relation S is decomposed using another set of functional dependencies, G. One decomposition is definitely BCNF, the other is definitely 3NF, but it is not known which is which. To make a quaranteed identification, which one of the following tests should be used on the decompositions? (Assume that the closures of F and G are available).
| Dependency-preservation | |
| Lossless-join | |
| BCNF definition | |
| 3NF definition |
Question 11 Explanation:
If it is BCNF then it is 3NF. But the relation is in 3NF then it is need not to be in BCNF.
Correct Answer: C
Question 11 Explanation:
If it is BCNF then it is 3NF. But the relation is in 3NF then it is need not to be in BCNF.