Pro SQL Server 2000 Database Design

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 (Compass.net) in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.

• Chapter 1: Introduction to Database Concepts 1 Chapter 2: Gathering Information for a Database Project 13 Chapter 3: Fundamental Database Concepts 27 Chapter 4: Entities, Attributes, Relationships, and Business Rules 55 Chapter 5: Data Modeling 91 Chapter 6: Normalization Techniques 129 Chapter 7: Advanced Normalization Topics 165 Chapter 8: Ending the Logical Design Phase 191 Chapter 9: Planning the Physical Architecture 219 Chapter 10: Building the Basic Table Structures 245 Chapter 11: Declarative Data Protection 315 Chapter 12: Programmatic Data Protection 341 Chapter 13: Advanced Data Access and Modification 367 Chapter 14: Determining Hardware Requirements 459 Chapter 15: Completing the Project 511