Pro SQL Server 2000 Database Design: Building Quality Oltp Databases

This book takes an in-depth, practical look at the process of designing and building efficient relational databases. It is a book of two halves. The first covers the logical design of databases, and the second looks at the physical design and implementation on SQL Server 2000.

Whereas many texts on this topic are rather dry and theoretical, this books considers design issues from a "real world" point of view. It covers the process of implementing a database using Microsoft SQL Server 2000 from the point where someone mentions to you that they want a database, all the way through to generating tables and implementing access to these tables. It provides a full and realistic case study that clearly illustrates the full process, from initial discussions of a client's needs, through development of a logical model, to a full implementation of the system.