Sample Header Ad - 728x90

Doubt on 2NF decomposition

1 vote
1 answer
125 views
I have read that 1NF, 2NF and 3NF decompositions are lossless and dependency-preserving. Consider this example on a relation **R(A,B,C,D)** with functional dependencies set as **FD ={ AB->CD, A->C, BC->D}** Here when we do 2NF decomposition we get **R1(A,C)** with **FD ={A->C}** and **R2(A,B,D)** with **FD ={AB->D}** The functional dependency **BC->D** is lost when we join but we know that 2NF is dependency preserving so why is it that we are unable to preserve the original FD?
Asked by Arun Madhav (11 rep)
Jan 7, 2023, 02:00 AM
Last activity: Dec 19, 2023, 02:22 AM