samedi 31 janvier 2015

database_quiestion_determine_2NF_3NF


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