Skip to main content
Improved the title
Link
ypercubeᵀᴹ
  • 98.7k
  • 13
  • 215
  • 305

Database normalization in Normalization to 2NF and 3NF

database_quiestion_determine_2NF_3NF Database normalization in 2NF and 3NF

added 58 characters in body
Source Link
ypercubeᵀᴹ
  • 98.7k
  • 13
  • 215
  • 305

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)

I solved this example to determine 2NF and 3NF. I would like to check my answer if it is corret. 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:

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)

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)
Source Link
chris
  • 11
  • 1
Loading