Table of contents for Designing effective database systems / Rebecca M. Riordan.

Bibliographic record and links to related information available from the Library of Congress catalog.

Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.


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

Library of Congress Subject Headings for this publication:

Database design.