• Designing Effective Database Systems
  • Table of Contents
  • Copyright
  • Praise for Designing Effective Database Systems
  • Preface
  • Acknowledgments
  • Part I:  Relational Database Theory
    • Chapter 1.  Basic Concepts
      • What Is a Database?
      • Database Tools
      • The Relational Model
      • Relational Terminology
      • The Data Model
      • Summary
    • Chapter 2.  Database Structure
      • Eliminating Redundancy
      • Ensuring Flexibility
      • Basic Principles
      • First Normal Form
      • Second Normal Form
      • Third Normal Form
      • Further Normalization
      • Summary
    • Chapter 3.  Relationships
      • Terminology
      • Modeling Relationships
      • One-to-One Relationships
      • One-to-Many Relationships
      • Many-to-Many Relationships
      • Unary Relationships
      • Ternary Relationships
      • Relationships of Known Cardinality
      • Summary
    • Chapter 4.  Data Integrity
      • Integrity Constraints
      • Implementing Data Integrity
      • Summary
    • Chapter 5.  Relational Algebra
      • Nulls and Three-Valued Logic (One More Time)
      • Relational Operations
      • Set Operators
      • Special Relational Operators
      • Summary
    • Part II:  Dimensional Database Theory
      • Chapter 6.  Basic Dimensional Concepts
        • The Dimensional Database Model
        • Terminology
        • A Potted History of Business Intelligence
        • Summary
      • Chapter 7.  Fact Tables
        • The Structure of a Fact Table
        • The Characteristics of a Fact Attribute
        • Summary
      • Chapter 8.  Dimension Tables
        • The Structure of a Dimension Table
        • Snowflaking
        • Changing Dimensions
        • Summary
      • Part III:  Designing Database Systems
        • Chapter 9.  The Design Process
          • Life Cycle Models
          • The Database Design Process
          • A Note on Design Methodologies and Standards
        • Chapter 10.  Defining the System Parameters
          • Determining the System Goals
          • Developing the Design Criteria
          • Determining the System Scope
          • Summary
        • Chapter 11.  Defining the Work Processes
          • Determining Current Work Processes
          • Analyzing Work Processes
          • Documenting Work Processes
          • User Scenarios
          • Summary
        • Chapter 12.  The Conceptual Data Model
          • Identifying the Data Objects
          • Defining Relationships
          • Reviewing Entities
          • Domain Analysis
          • Restricting the Range of Values
          • Normalization
          • Summary
        • Chapter 13.  The Database Schema
          • Systems Architectures
          • Database Schema Components
          • Security
          • Summary
        • Chapter 14.  Communicating the Design
          • Audience and Purpose
          • Document Structure
          • Executive Summary
          • System Overview
          • Work Processes
          • Conceptual Data Model
          • Database Schema
          • User Interface
          • Change Management
          • Summary
        • Part IV:  Designing the User Interface
          • Chapter 15.  The Interface as Mediator
            • Effective Interfaces
            • Interface Models
            • User Levels
            • Putting Users in Charge
            • Minimizing the Memory Load
            • Being Consistent
            • Summary
          • Chapter 16.  User Interface Architectures
            • Supporting the Work Processes
            • Document Architectures
            • Summary
          • Chapter 17.  Representing Entities in Form Design
            • Simple Entities
            • One-to-One Relationships
            • One-to-Many Relationships
            • Hierarchies
            • Many-to-Many Relationships
            • Summary
          • Chapter 18.  Choosing Windows Controls
            • Representing Logical Values
            • Representing Sets of Values
            • Representing Numbers and Dates
            • Representing Text Values
            • Summary
          • Chapter 19.  Maintaining Database Integrity
            • Classes of Integrity Constraints
            • Intrinsic Constraints
            • Business Constraints
            • Summary
          • Chapter 20.  Reporting
            • Sorting, Searching, and Filtering Data
            • Producing Standard Reports
            • Producing Ad Hoc Reports
            • Summary
          • Chapter 21.  User Assistance
            • User Levels
            • Passive Assistance Mechanisms
            • Reactive Assistance Mechanisms
            • Proactive Assistance
            • User Training
            • Summary
          • Bibliography
            • Part I: Relational Database Theory
            • Part II: Designing Relational Database Systems
            • Part III: Designing the User Interface
          • Glossary