Cover image for Pro SQL server 2000 database design : building quality OLTP databases
Pro SQL server 2000 database design : building quality OLTP databases
Davidson, Louis.
Personal Author:
Publication Information:
Berkeley, Calif. : Apress ; London : Springer, [2004]

Physical Description:
xxiv, 567 pages : illustrations ; 24 cm.
General Note:
Includes index.
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D26 D385 2004 Adult Non-Fiction Central Closed Stacks

On Order



* Obtain a deep understanding of database design and modeling concepts.

* Implement a complete case study, from initial requirements gathering, right up to the point where it is up and running on SQL Server 2000.

* Design and build relational databases that will be more efficient and productive for your organization.

Author Notes

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology ( in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.

Table of Contents

Chapter 1 Introduction to Database Conceptsp. 1
Chapter 2 Gathering Information for a Database Projectp. 13
Chapter 3 Fundamental Database Conceptsp. 27
Chapter 4 Entities, Attributes, Relationships, and Business Rulesp. 55
Chapter 5 Data Modelingp. 91
Chapter 6 Normalization Techniquesp. 129
Chapter 7 Advanced Normalization Topicsp. 165
Chapter 8 Ending the Logical Design Phasep. 191
Chapter 9 Planning the Physical Architecturep. 219
Chapter 10 Building the Basic Table Structuresp. 245
Chapter 11 Declarative Data Protectionp. 315
Chapter 12 Programmatic Data Protectionp. 341
Chapter 13 Advanced Data Access and Modificationp. 367
Chapter 14 Determining Hardware Requirementsp. 459
Chapter 15 Completing the Projectp. 511