Designing relational database systems

Topics covered
include:

• The basic guiding principles, tools, and techniques of
  the relational database model
  
• The rich set of tools for database
  development available from Microsoft—from Microsoft Access 2000 and SQL
  Server 7.0 to the database technologies in Microsoft Visual
  Basic
  
• Solving relational database design problems in real-world
  scenarios
  
• Creating effective user interfaces for your database
  systems
  
• Determining data structures based on work processes

Table of contents

Forward

Acknowledgments

Introduction

Part I: Relational Database Theory

Chapter 1: Basic Concepts

Chapter 2: Database Structure

Chapter 3: Relationships

Chapter 4: Data Integrity

Chapter 5: Relational Algebra

Part II: Designing Relational Database Systems

Chapter 6: The Design Process

Chapter 7: Defining the System Parameters

Chapter 8: Defining the Work Processes

Chapter 9: The Conceptual Data Model

Chapter 10: The Database Schema

Chapter 11: Communicating the Design

Part III: DESIGNING THE USER INTERFACE

Chapter 12: The Interface as Mediator

Chapter 13: System Architectures

Chapter 14: Representing Entities in Form Design

Chapter 15: Choosing Windows Controls

Chapter 16: Maintaining Database Integrity

Chapter 17: Reporting

Chapter 18: User Assistance and Interaction

Appendix: Analysis Forms

Annotated Bibliography

Glossary