BANK SEBI Grade A Phase 1 & Phase 2 Mock Test 2024 DBMS Integrity Constraints and Normal Form Functional Dependency
Suppose there is a relation R (A, B, C, D) with functional dependency set (A → BC). The relational R is decomposed into R1(ABC) and R2(AD). The decomposition is ____.
1
Lossy
2
Lossless
3
Dependency Preserving
4
Both 1 and 3
5
Both 2 and 3