Give a lossless, dependency-preserving decomposition into 3NF of schema of Exercise 7.1.
Use the algorithm given in Figure 7.12.
Also don’t forget that (see exercise 7.7)
1 min read
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}