DBMS-Decomposition

Question

Which of the following statement is true while decomposition ?

1.  3NF guaranteed dependency preserving
2. 3NF guaranteed lossless property
3. Both of the above
4. None of the above

Comments

ans 3

Answer 1

Both are correct

1NF ..2 NF....3NF guarantees loseless and dependency preserving

while BCNF guarantee loseless decomposition but doesn't guarantee dependency preserving

Answer 2

Both are correct