First page Back Continue Last page Graphics
Third Normal Form
Decomposition into 3NF
Example
- R=(L, I, T, R, S, G)
- F: {L I, TR L, TI R, LS G, TS R, TRI LR}
- Are all FDs necessary? No !
- TR L, TI R then TRI LR
- Canonical cover of F
- Fc= {L I, TR L, TI R, TS R, LS G}
- Key: (ST)
- Key attributes: S, T
Notes: