Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Meow
Starting Member
8 Posts |
 Posted - 2006-01-20 : 13:21:43
|
| 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 muchm~ |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2006-01-20 : 16:10:23
|
| Hi there,This is such a broad question you may find difficulty getting a direct answer here on the forums. I would start by reading any of the many available articles on database design theory.ex. http://www.15seconds.com/issue/020522.htmAnd definitely acquire a book. There are many by Ken Henderson, Kalen Delaney, CJ Date, EF Codd, etc that you can find on the Net. Bookpool.com is a great resource for discount tech books.Once you get up and running with your design you can post back here with specific questions / roadblocks. You will find that Sqlteam is an amazing resource to have.Nathan Skerl |
 |
|
|
|
|
|
Acc Pay DB design