7.22

Give a lossless, dependency-preserving decomposition into 3NF of schema R of Exercise 7.1.


Use the algorithm given in Figure 7.12.

Also don’t forget that F=Fc (see exercise 7.7)

R1={A,B,C}R2={C,D,E}R3={B,D}R4={E,A}