I solved this example to determine 2NF and 3NF. I would like to check if my answer if it is corretcorrect. Can somebody check the 2NF and 3NF of this example, please? R( A B C D E F G H I J) with functional dependecies AB -> C, A -> DE, B -> F, F -> GH, D -> IJ.
My result:
R( A B C D E F G H I J)
2NFwith functional dependencies: R1 (AB -> C , A -> E) R2 (B -> F , F -> GH) R3 (D -> I)
AB -> C
A -> DE
B -> F
F -> GH
D -> IJ
3NFMy result: R1 (AB -> C , A -> E) R2 (B -> F) R4 (F -> GH) R3 (D -> I)
2NF:
R1 (AB -> C , A -> E)
R2 (B -> F , F -> GH)
R3 (D -> I)
3NF:
R1 (AB -> C , A -> E)
R2 (B -> F)
R4 (F -> GH)
R3 (D -> I)