I solved this example to determine 2NF and 3NF. I would like to check if my answer is correct. Can somebody check the 2NF and 3NF of this example, please?
R( A B C D E F G H I J)
with functional dependencies:
AB -> C
A -> DE
B -> F
F -> GH
D -> IJ
My result:
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)
Aucun commentaire:
Enregistrer un commentaire