Chapter 3 of the textbook has lots of exercises on database design. The CD project is particularly good as it shows a seemingly simple design task can get quite complicated with some additional requirements and considerations.