Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 277 |
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 guaranteed identification, which one of the following tests should be used on the decompositions? (Assume that the closure of F and G are available).
| Lossless-join | |
| BCNF definition | |
| 3NF definition | |
| Dependency-Preservation |
Question 277 Explanation:
Since one decomposition is in 3NF so it will not satisfy the BCNF conditions.Hence BCNF tests should be used on the decompositions.
Correct Answer: B
Question 277 Explanation:
Since one decomposition is in 3NF so it will not satisfy the BCNF conditions.Hence BCNF tests should be used on the decompositions.