Given a relation schema R = (A, B, C,G,H,1) and a functional and multivalued dependencies D...

Transcribed Image Text:

Given a relation schema R = (A, B, C,G,H,1) and a functional and multivalued dependencies D = %3D {A B,B → HI, CGH}, R is not in 4NF since A B and A is not a superkey for R. After finishing 4NF, we can decompose R into following 4 small relation schemas: R1 = (A, B) R2 = _(43) R3 = (A,I) R4 = (A, C, G) Given a relation schema R = (A, B, C,G,H,1) and a functional and multivalued dependencies D = %3D {A B,B → HI, CGH}, R is not in 4NF since A B and A is not a superkey for R. After finishing 4NF, we can decompose R into following 4 small relation schemas: R1 = (A, B) R2 = _(43) R3 = (A,I) R4 = (A, C, G)