engineering recuitment GATE CSE 2023-24 Test Series DBMS Integrity Constraints and Normal Form Normal Form
Consider the relation R(X, Y, W, Z, P, Q), and the set F = {XY → W, XW → P, PQ → Z, XY → Q}. R is decomposed into R1(Z, P, Q) and R2(X, Y, W, P, Q). Which of the following is true about R?
1
Only lossless decomposition
2
Only dependency preserving decomposition
3
Neither lossless decomposition nor dependency preserving decomposition
4
Both lossless decomposition and dependency preserving decomposition