engineering recuitment RPSC Programmer Mock Test 2024 DBMS Integrity Constraints and Normal Form Normal Form
If D = {R1, R2} is a decomposition of R, and F is the set of functional dependencies on R, then which of the following ensures that the decomposition D is lossless (nonadditive)?
1
((R1 ∩ R2) → (R1 – R2)) ∈ F+
2
((R1 ∩ R2) → (R1 – R2)) ∉ F+
3
((R1 ∩ R2) → R1) ∈ F+
4
((R1 ∪ R2) → (R1 – R2)) ∈ F+
5
Question Not Attempted