First page Back Continue Last page Graphics
Third Normal Form
Decomposition into 3NF
Example
- Semester database of a university
- Relational schema R=(L, I, T, R, S, G)
- Attributes
- L: Lecture R: Room
- I: Instructor S: Student
- G: Grade T: Time
- Functional Dependencies
- L I, TR L, TI R, LS G, TS R, TRI LR
Notes: