---

Designing Relational Database Systems (Dv-Mps Designing)

ISBN: 073560634X
EAN: 2147483647

Year: 1999
Pages: 124

Authors: Rebecca M. Riordan

BUY ON AMAZON

• Cover
• LOC Page
• Foreword
• Acknowledgments
• Introduction
• 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
• 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
• 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