•
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