Design Help - How to get the Best Design

Dear Experts
Originally in about 1986/87 I was a cobol programmer and was used to doing
things the Master Transaction way. After a long gap i am currently in a
situation of
working with SQL Server 7.0 but somehow i feel my design leans on Master
Transaction Style where i increment the balance in master after every
transaction. MY Question is As Follows:
1. What is the yard stick for a great DB Design.?
2. What kind of Book Should i Read?
3. Any Pointers and Help on Database Design Sample or
courses i can take would be greatly appreciated.
Thanks in Advance and i apologize for this post if it is not in the right
forum.
Manish
Three Cheers to technet for the Help!Look at
http://www.databaseanswers.org/data_models/index.htm
for some samples:
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> schrieb im
Newsbeitrag news:27506C1E-A756-4506-AF2D-368E757A82B5@.microsoft.com...
> Dear Experts
> Originally in about 1986/87 I was a cobol programmer and was used to doing
> things the Master Transaction way. After a long gap i am currently in a
> situation of
> working with SQL Server 7.0 but somehow i feel my design leans on Master
> Transaction Style where i increment the balance in master after every
> transaction. MY Question is As Follows:
> 1. What is the yard stick for a great DB Design.?
> 2. What kind of Book Should i Read?
> 3. Any Pointers and Help on Database Design Sample or
> courses i can take would be greatly appreciated.
> Thanks in Advance and i apologize for this post if it is not in the right
> forum.
> Manish
>
> --
> Three Cheers to technet for the Help!