Need assistance with 3NF decomposition

123 views Asked by At

The relation R(A,B,C,D,E) has functional dependencies A -> B,C,D,E and BCD -> E

A is a key. However, this relation is not in 3NF since BCD -> E is a violation, where E is not a prime attribute and BCD is not a superkey. So if we decompose the relation, do we get

R1(A,B,C,D) and R2(B,C,D,E) ? or am I incorrect in this decomposition

1

There are 1 answers

2
serge On

Your decomposition is right but technically, you'd better introduce a third relation because the composite primary key is not a good practice at DBA viewpoint.

R1(A [PK], X)
R2(X [PK], B, C, D)
R3(X [PK], E)