| |
| |
| Preface | |
| |
| |
| About the Author | |
| |
| |
| |
| Data: The New Corporate Resource | |
| |
| |
| The History of Data | |
| |
| |
| The Origins of Data | |
| |
| |
| Data Through the Ages | |
| |
| |
| Early Data Problems Spawn Calculating Devices | |
| |
| |
| Swamped with Data | |
| |
| |
| Modern Data Storage Media | |
| |
| |
| Data in Today''s Information Systems Environment | |
| |
| |
| Using Data for Competitive Advantage | |
| |
| |
| Problems in Storing and Accessing Data | |
| |
| |
| Data as a Corporate Resource | |
| |
| |
| The Database Environment | |
| |
| |
| |
| Simple File Storage and Retrieval | |
| |
| |
| What Is Data? | |
| |
| |
| Important Objects and Facts | |
| |
| |
| Records and Files | |
| |
| |
| Basic Concepts in Storing and Retrieving Data | |
| |
| |
| Retrieving and Manipulating Data | |
| |
| |
| Disk Storage | |
| |
| |
| The Need for Disk Storage | |
| |
| |
| How Disk Storage Works,File Organizations and Access Methods | |
| |
| |
| The Goal: Locating a Record | |
| |
| |
| The Index | |
| |
| |
| Hashed Files | |
| |
| |
| |
| Data Modeling | |
| |
| |
| Introduction | |
| |
| |
| Binary Relationships | |
| |
| |
| What Is a Binary Relationship? | |
| |
| |
| Cardinality | |
| |
| |
| Modality | |
| |
| |
| More About Many-to-Many Relationships | |
| |
| |
| Unary Relationships | |
| |
| |
| One-to-One Unary Relationship | |
| |
| |
| One-to-Many Unary Relationship | |
| |
| |
| Many-to-Many Unary Relationship | |
| |
| |
| Ternary Relationships | |
| |
| |
| Examples | |
| |
| |
| The General Hardware Company | |
| |
| |
| Good Reading Bookstores | |
| |
| |
| World Music Association | |
| |
| |
| Lucky Rent-A-Car | |
| |
| |
| |
| The Database Management System Concept | |
| |
| |
| The Database Concept | |
| |
| |
| Data as a Manageable Resource | |
| |
| |
| Data Integration and Data Redundancy | |
| |
| |
| Multiple Relationships | |
| |
| |
| Data Control Issues | |
| |
| |
| Data Independence | |
| |
| |
| DBMS Approaches | |
| |
| |
| |
| The Relational Database Model: Introduction | |
| |
| |
| The Relational Database Concept | |
| |
| |
| Relational Terminology | |
| |
| |
| Primary and Candidate Keys | |
| |
| |
| Foreign Keys and Binary Relationships | |
| |
| |
| Data Retrieval from a Relational Database | |
| |
| |
| Extracting Data from a Relation | |
| |
| |
| The Relational Select Operator | |
| |
| |
| The Relational Project Operator | |
| |
| |
| Combination of the Relational Select and Project Operators | |
| |
| |
| Extracting Data Across Multiple Relations: Data Integration | |
| |
| |
| Example: Good Reading Bookstores | |
| |
| |
| Example: World Music Association | |
| |
| |
| Example: Lucky Rent-A-Car | |
| |
| |
| |
| The Relational Database Model: Additional Concepts | |
| |
| |
| Relational Structures for Unary and Ternary Relationships | |
| |
| |
| Unary One-to-Many Relationships | |
| |
| |
| Unary Many-to-Many Relationships | |
| |
| |
| Ternary Relationships | |
| |
| |
| Referential Integrity | |
| |
| |
| The Referential Integrity Concept | |
| |
| |
| Three Delete Rules | |
| |
| |
| |
| Logical Database Design | |
| |
| |
| Converting E-R Diagrams into Relational Tables | |
| |
| |
| Introduction | |
| |
| |
| Converting a Simple Entity | |
| |
| |
| Converting Entities in Binary Relationships | |
| |
| |
| Converting Entities in Unary Relationships | |
| |
| |
| Converting Entities in Ternary Relationships | |
| |
| |
| Designing the General Hardware Company Database | |
| |
| |
| Designing the Good Reading Bookstores Database | |
| |
| |
| Designing the World Music Association Database | |
| |
| |
| Designing the Lucky Rent-A-Car Database | |
| |
| |
| The Data Normalization Process | |
| |
| |
| Introduction to the Data Normalization Technique | |
| |
| |
| Steps in the Data Normalization Process | |
| |
| |
| General Hardware Company Example | |
| |
| |
| Good Reading Bookstores Example | |
| |
| |
| World Music Association Example | |
| |
| |
| Lucky Rent-A-Car Example | |
| |
| |
| Testing Tables Converted from E-R Diagrams with Data Normalization | |
| |
| |
| |
| Physical Database Design | |
| |
| |
| Inputs to Physical Database Design | |
| |
| |
| The Tables Produced by the Logical Database Design Process | |
| |
| |
| Business Environment Requirements | |
| |
| |
| Data Characteristics | |
| |
| |
| Application Characteristics | |
| |
| |
| Operational Requirements: Data Security, Backup and Recovery | |
| |
| |
| Hardware and Software Characteristics | |
| |
| |
| Physical Database Design Techniques | |
| |
| |
| Adding External Features | |
| |
| |
| Reorganizing Stored Data | |
| |
| |
| Splitting a Table into Multiple Tables | |
| |
| |
| Changing Attributes in a Table | |
| |
| |
| Adding Attributes to a Table | |
| |
| |
| Combining Tables | |
| |
| |
| Adding New Tables | |
| |
| |
| Example: Good Reading Bookstores | |
| |
| |
| Example: World Music Association | |
| |
| |
| Example: Lucky Rent-A-Car | |
| |
| |
| |
| Relational Data Retrieval: SQL | |
| |
| |
| SQL Commands | |
| |
| |
| Building the Data Structure | |
| |
| |
| Data Manipulation Operations | |
| |
| |
| Data Retrieval with the SQL SELECT Command | |
| |
| |
| Introduction to the SQL SELECT Command | |
| |
| |
| Basic Functions | |
| |
| |
| Built-In Functions | |
| |
| |
| Grouping Rows | |
| |
| |
| The Join | |
| |
| |
| Subqueries | |
| |
| |
| A Strategy for Writing SQL SELECT Commands | |
| |
| |
| Example: Good Reading Bookstores | |
| |
| |
| Example: World Music Association | |
| |
| |
| Example: Lucky Rent-A-Car | |
| |
| |
| Relational Query Optimizer | |
| |
| |
| Relational DBMS Performance | |
| |
| |
| Relational Query Optimizer Concepts | |
| |
| |
| Cha | |