First page Back Continue Last page Graphics
Third Normal Form
Informal Presentation
Motivation
- Sometimes a relational schema and its FDs are not in BCNF but one does not want to decompose further
- Example:
- Relation Bookings with attributes:
- title, the name of the performance
- theater, the name of the theater where the performance is being shown
- city, where the theater is located
- FDs are: theater city, title city theater
- Is there a BCNF violation?
Notes: