Teaching UGC NET Mock Test Series 2025 (Paper 1 & 2) DBMS Integrity Constraints and Normal Form Normal Form
Which of the following relations can not be decomposed in to BCNF with a lossless join and dependency-preserving decomposition ?
1
R (V, W, X, Y, Z) (VW → X, WX → V, VX → W, W → Y, Y → Z)
2
R (V, W, X, Y) {VW → W, X → Y}
3
R (V, W, X, Y) (VW → X, X → VY}
4
R (V, W, X, Y, Z) (VW → X, X → Y, Y → Z, Z → V}