1.1 | Introduction 2 |
1.2 | Database Design 2 |
1.2.1 Conceptual View 2 | |
1.2.2 Table Definitions 3 | |
1.2.3 Redundant Information 4 | |
1.2.4 Normalization 4 | |
1.2.5 Normalization Strategies 5 | |
1.2.6 Third Normal Form (3NF) 6 | |
1.2.7 Beyond Third Normal Form 7 | |
1.3 | Column Names and Reserved Words 8 |
1.4 | Data Integrity 9 |
1.4.1 Referential Integrity 9 | |
1.5 | Database Tables Used in This Book 10 |
1.5.1 CUSTOMERS Table 10 | |
1.5.2 INVENTORY Table 11 | |
1.5.3 INVOICE Table 11 | |
1.5.4 MANUFACTURERS Table 12 | |
1.5.5 PRODUCTS Table 12 | |
1.5.6 PURCHASES Table 13 | |
1.6 | Table Contents 13 |
1.6.1 The Database Structure 16 | |
1.6.2 Sample Database Tables 17 | |
1.7 | Summary 21 |