| |
| |
| Foreword | |
| |
| |
| Preface and Acknowledgments | |
| |
| |
| |
| Relational Database Design | |
| |
| |
| |
| What Is a Relational Database? | |
| |
| |
| Types of Databases | |
| |
| |
| Early Database Models | |
| |
| |
| The Hierarchical Database Model | |
| |
| |
| The Network Database Model | |
| |
| |
| The Relational Database Model: A Brief History | |
| |
| |
| Relational Database Management Systems | |
| |
| |
| |
| Design Objectives | |
| |
| |
| Why Should You Be Concerned with Database Design? | |
| |
| |
| The Importance of Theory | |
| |
| |
| The Advantage of Learning Good Design Methodology | |
| |
| |
| The Importance of Understanding Database Design | |
| |
| |
| Objectives of Good Design | |
| |
| |
| Advantages of Good Design | |
| |
| |
| Database Design Methods | |
| |
| |
| Traditional Design Methods | |
| |
| |
| The Design Method Presented in This Book | |
| |
| |
| |
| Terminology | |
| |
| |
| Why This Terminology Is Important | |
| |
| |
| Value-related Terms | |
| |
| |
| Data | |
| |
| |
| Information | |
| |
| |
| Null | |
| |
| |
| Structure-related Terms | |
| |
| |
| Table | |
| |
| |
| Field | |
| |
| |
| Record | |
| |
| |
| View | |
| |
| |
| Keys | |
| |
| |
| Index | |
| |
| |
| Relationship-related Terms | |
| |
| |
| Relationships | |
| |
| |
| Types of Relationships | |
| |
| |
| Types of Participation | |
| |
| |
| Degree of Participation | |
| |
| |
| Integrity-related Terms | |
| |
| |
| Field Specification | |
| |
| |
| Data Integrity | |
| |
| |
| |
| The Design Process | |
| |
| |
| |
| Conceptual Overview | |
| |
| |
| The Importance of Completing the Design Process | |
| |
| |
| Defining a Mission Statement and Mission Objectives | |
| |
| |
| Analyzing the Current Database | |
| |
| |
| Creating the Data Structures | |
| |
| |
| Determining and Establishing Table Relationships | |
| |
| |
| Determining and Defining Business Rules | |
| |
| |
| Determining and Establishing Views | |
| |
| |
| Reviewing Data Integrity | |
| |
| |
| |
| Starting the Process | |
| |
| |
| Conducting Interviews | |
| |
| |
| The Case Study: Mike's Bikes | |
| |
| |
| Defining the Mission Statement | |
| |
| |
| The Well-written Mission Statement | |
| |
| |
| Composing a Mission Statement | |
| |
| |
| Case Study | |
| |
| |
| Defining the Mission Objectives | |
| |
| |
| Well-written Mission Objectives | |
| |
| |
| Composing Mission Objectives | |
| |
| |
| Case Study | |
| |
| |
| |
| Analyzing the Current Database | |
| |
| |
| Getting to Know the Current Database | |
| |
| |
| Paper-based Databases | |
| |
| |
| Legacy Databases | |
| |
| |
| Conducting the Analysis | |
| |
| |
| Looking at How Data Is Collected | |
| |
| |
| Looking at How Information Is Presented | |
| |
| |
| Conducting Interviews | |
| |
| |
| Conducting User Interviews | |
| |
| |
| Reviewing Data Type and Usage | |
| |
| |
| Reviewing the Samples | |
| |
| |
| Reviewing Information Requirements | |
| |
| |
| Conducting Management Interviews | |
| |
| |
| Reviewing Current Information Requirements | |
| |
| |
| Reviewing Additional Information Requirements | |
| |
| |
| Reviewing Future Information Requirements | |
| |
| |
| Reviewing Overall Information Requirements | |
| |
| |
| Compiling a Complete List of Fields | |
| |
| |
| The Preliminary Field List | |
| |
| |
| The Calculated Field List | |
| |
| |
| Reviewing Both Lists with Users and Management | |
| |
| |
| Case Study | |
| |
| |
| |
| Establishing Table Structures | |
| |
| |
| Defining the Preliminary Table List | |
| |
| |
| Determining Implied Subjects | |
| |
| |
| Using the List of Subjects | |
| |
| |
| Using the Mission Objectives | |
| |
| |
| Defining the Final Table List | |
| |
| |
| Refining the Table Names | |
| |
| |
| Indicating the Table Types | |
| |
| |
| Composing the Table Descriptions | |
| |
| |
| Associating Fields with Each Table | |
| |
| |
| Refining the Fields | |
| |
| |
| Improving the Field Names | |
| |
| |
| Using the Ideal Fi | |