Team LiB
Previous Section Next Section
   
Book Cover
  
• Table of Contents
Designing Effective Database Systems
By Rebecca M. Riordan
 
Publisher: Addison Wesley Professional
Pub Date: January 10, 2005
ISBN: 0-321-29093-3
Pages: 384
   


   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

Team LiB
Previous Section Next Section