Normalization

Question

Given the following set of FD's find the minimum set of 3 NF relations.

A->B

A->C

B->C

B->D

D->B

ABE->F

E->J

EJ->H

H->G

Answer 1

5 Relations in 3NF i.e HG, EHJ, BCD, AB, AEF

Steps followed : 

Find minimal FD’s set by removing redundancies. – remove 2NF violation by decomposing – remove 3 NF violation by decomposing.