Book Description

Database design is one of the most contentious issues in computer science. There is always a delicate balance to be struck between the strict academic rules that govern the design of relational databases and the real-world techniques that programmers apply to get the job done in a certain time frame. This book's goal is to cover—from a "real-world" point of view—all of the essential elements in designing, modeling, and building efficient relational databases, while avoiding a dry, theoretical approach.

Author Louis Davidson explains the process of implementing a database—from generating tables and allowing access to these tables using Microsoft SQL Server 2000. This includes tackling data modeling (focusing on the IDEF1X notation), requirements gathering, normalization (beyond the Third Normal Form), and implementing tables, constraints, triggers, procedures, user-defined functions, and so on. Davidson provides a full and realistic case study that clearly illustrates the entire process, from the initial discussions of a client's needs, through development of a logical model, to a complete implementation of the system.

Download Description

Pro SQL Server 2000 Database Design 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 conception of the database and its design considerations 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.

Book Info
Guide covers the essential elements in designing, modeling, and building efficient relational databases. Explains the process of implementing a database, including generating tables and allowing access to those tables using Microsoft SQL Server 2000. Softcover.

About the Author
Louis Davidson has been in the IT industry for 10 years as a corporate database developer and architect. He is currently a database administrator for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee. <p>Davidson has a bachelor’s degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics. The majority of his experience has been with Microsoft SQL Server from version 1.0 to the latest version (currently in beta). His areas of expertise are database architecture and coding in T-SQL, and he has written thousands of stored procedures and triggers through the years. In October 2004, Davidson was named a Microsoft MVP for SQL Server.</p>