I've found Louis Davidson's Pro SQL Server Relation Design & Implementation and the Star Schema: The Complete Reference to be excellent resources.

Like Aaron said, you really need to be familiar with the data flow.  Logical modelling has been a big help in that area.  Database Design is also somewhat of an art in addition to science.  You can over normalize just as easily as not normalize enough.