Unformatted text preview: g. adjacent fields Exercise 2 Explain why normalized relations may not comprise an efficient physical implementation structure and list three common situations that suggest that relations be denormalized before database implementation. Exercise 3 Consider the following two relations for Millennium College: On what attributes should indexes be defined to speed up this query? Give the reasons for each attribute selected....
View Full Document
- Spring '16
- Luyen Thu Trang
- Database normalization, Algorithmic efficiency