First page Back Continue Last page Graphics
Third Normal Form
Decomposition into 3NF
Example
- R = (L, I, T, R, S, G)
- Fc = {L I, TR L, TI R, TS R, LS G}
- Key attributes: S, T
- Decomposition in 3NF
- R1 = (L, I) R2 = (T, R, L)
- R3 = (T, I, R) R4 = (L, S, G)
- R5 = (S, T, R)
Notes: