I have an access db that was designed VERY poorly, no relationships, every field nullable and so on.

I am moving it to sql server and want to design this db well can anyone recomend a book on db design or are there like design patterns i can lookup some where?

Its a Acct/Pay db, that allocates exp to varios investment deals if any one can suggest i appreciated it very much