Designing Relational Database Systems (Dv-Mps Designing)

Rebecca Riordan, Microsoft Pr

ISBN:073560634X, Edition: , 1999-09

Price: $39.99

Contents

Cover
LOC Page
Foreword
Acknowledgments
Introduction

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
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 Operators
Set Operators
Special Relational Operators
Summary

Part II: Designing Relational Database Systems

Chapter 6 -- The Design Process
Life Cycle Models
The Database Design Process
A Note on Design Methodologies and Standards

Chapter 7 -- Defining the System Parameters
Determining the System Goals
Developing the Design Criteria
Determining the System Scope
Summary

Chapter 8 -- Defining the Work Processes
Determining Current Work Processes
Analyzing Work Processes
Documenting Work Processes
User Scenarios
Summary

Chapter 9 -- The Conceptual Data Model
Identifying the Data Objects
Defining Relationships
Reviewing Entities
Domain Analysis
Normalization
Summary

Chapter 10 -- The Database Schema
Systems Architectures
Database Schema Components
Security
Summary

Chapter 11 -- Communicating the Design
Audience and Purpose
Document Structure
Executive Summary
System Overview
Work Processes
Conceptual Data Model
Database Schema
User Interface
Change Management
Special Tools
Summary

Part III: Designing the User Interface

Chapter 12 -- The Interface as Mediator
Effective Interfaces
Interface Models
User Levels
Putting Users in Charge
Minimizing the Memory Load
Being Consistent
Summary

Chapter 13 -- User Interface Architectures
Supporting the Work Processes
Document Architectures
Summary

Chapter 14 -- Representing Entities in Form Design
Simple Entities
One-to-One Relationships
One-to-Many Relationships
Hierarchies
Many-to-Many Relationships
Summary

Chapter 15 -- Choosing Windows Controls
Representing Logical Values
Representing Sets of Values
Representing Numbers and Dates
Representing Text Values
Summary

Chapter 16 -- Maintaining Database Integrity
Classes of Integrity Constraints
Intrinsic Constraints
Business Constraints
Summary

Chapter 17 -- Reporting
Sorting, Searching, and Filtering Data
Producing Standard Reports
Producing Ad Hoc Reports
Summary

Chapter 18 -- User Assistance
Passive Assistance Mechanisms
Reactive Assistance Mechanisms
Proactive Assistance
User Training
Summary

Footnotes
Glossary
Bibliography
About the Author