- Copyright
- Copyright
- Praise for Database Design for Mere Mortals, Second Edition
- Praise for the First Edition
- About the Author
- Foreword
- From the First Edition . . .
- Preface (Second Edition)
- Acknowledgments
- Preface (First Edition)
- Acknowledgments
- Introduction
- What s New in the Second Edition
- Who Should Read This Book
- The Purpose of This Book
- How to Read This Book
- How This Book Is Organized
- A Word About the Examples and Techniques in This Book
- Part I: Relational Database Design
- Chapter 1. The Relational Database
- Topics Covered in This Chapter
- Types of Databases
- Early Database Models
- The Relational Database Model
- Relational Database Management Systems
- Beyond the Relational Model
- What the Future Holds
- Summary
- Review Questions
- Chapter 2. Design Objectives
- Topics Covered in This Chapter
- Why Should You Be Concerned with Database Design?
- The Importance of Theory
- The Advantage of Learning a Good Design Methodology
- Objectives of Good Design
- Benefits of Good Design
- Database-Design Methods
- Summary
- Review Questions
- Chapter 3. Terminology
- Topics Covered in This Chapter
- Why This Terminology Is Important
- Value-Related Terms
- Structure-Related Terms
- Relationship-Related Terms
- Integrity-Related Terms
- Summary
- Review Questions
- Part II: The Design Process
- Chapter 4. Conceptual Overview
- Topics Covered in This Chapter
- The Importance of Completing the Design Process
- Defining a Mission Statement and Mission Objectives
- Analyzing the Current Database
- Creating the Data Structures
- Determining and Establishing Table Relationships
- Determining and Defining Business Rules
- Determining and Defining Views
- Reviewing Data Integrity
- Summary
- Review Questions
- Chapter 5. Starting the Process
- Topics Covered in This Chapter
- Conducting Interviews
- The Case Study: Mike s Bikes
- Defining the Mission Statement
- Defining the Mission Objectives
- Summary
- Review Questions
- Chapter 6. Analyzing the Current Database
- Topics Covered in This Chapter
- Getting to Know the Current Database
- Conducting the Analysis
- Looking at How Data Is Collected
- Looking at How Information Is Presented
- Conducting Interviews
- Interviewing Users
- Interviewing Management
- Compiling a Complete List of Fields
- Summary
