Pro SQL Server 2008 Relational Database Design and Implementation

Cover -- TOC$Contents -- Foreword -- About the Author -- About the Technical Reviewers -- Acknowledgments -- Introduction -- CH$CHAPTER 1 Introduction to Database Concepts -- Database Design Phases -- Conceptual -- Logical -- Implementation -- Physical -- Relational Data Structures -- Database and Schema -- Tables, Rows, and Columns -- The Information Principle -- Domains -- Metadata -- Keys -- Missing Values (NULLs) -- Relationship Between Entities -- Data Access Language (SQL) -- Understanding Dependencies -- Functional Dependency -- Determinant -- Summary -- CH$CHAPTER 2 The Language of Data Modeling -- Introduction to Data Modeling -- Entities -- Attributes -- Primary Keys -- Alternate Keys -- Foreign Keys -- Domains -- Naming -- Relationships -- Identifying Relationships -- Nonidentifying Relationships -- Role Names -- Relationship Cardinality -- Verb Phrases (Relationship Names) -- Descriptive Information -- Alternative Modeling Methodologies -- Information Engineering -- Chen ERD -- Visio -- Management Studio Database Diagrams -- Best Practices -- Summary -- CH$CHAPTER 3 Conceptual Data Modeling -- Understanding the Requirements -- Documenting the Process -- Requirements Gathering -- Client Interviews -- Questions to Be Answered -- Existing Systems and Prototypes -- Other Types of Documentation -- Identifying Objects and Processes -- Identifying Entities -- Relationships Between Entities -- Identifying Attributes and Domains -- Identifying Business Rules and Processes -- Identifying Business Rules -- Identifying Fundamental Processes -- Finishing the Conceptual Model -- Identifying Obvious Additional Data Needs -- Review with the Client -- Repeat Until the Customer Agrees with Your Model -- Best Practices -- Summary -- CH$CHAPTER 4 The Normalization Process -- Why Normalize? -- Eliminating Duplicated Data -- Avoiding Unnecessary Coding -- Keeping Tables Thin -- Maximizing Clustered Indexes -- Lowering the Number of Indexes Per Table -- How Far to Normalize? -- The Process of Normalization -- Entity and Attribute Shape: First Normal Form -- All Attributes Must Be Atomic -- All Instances in an Entity Must Contain the Same Number of Values -- All Occurrences of an Entity Type in an Entity Must Be Different -- Programming Anomalies Avoided by First Normal Form -- Clues That An Existing Design Is Not in First Normal Form -- Relationships Between Attributes -- Second Normal Form -- Third Normal Form -- Boyce-Codd Normal Form -- Multivalued Dependencies in Entities -- Fourth Normal Form -- Fifth Normal Form -- Denormalization -- Best Practices -- Summary -- Bonus Example -- The Story of the Book So Far -- CH$CHAPTER 5 Implementing the Base Table Structures -- Reviewing the Logical Design -- Transforming the Design -- Choosing Names -- Dealing with Subtypes -- Determining Tree Implementation -- Choosing Key Implementation -- Determining Domain Implementation -- Setting Up Schemas -- Reviewing the "Final" Implementation Model -- Implementing the Design -- Creating the Basic Table Structures -- Adding Uniqueness Constraints -- Building.