Database Design for Mere Mortals A Hands-On Guide to Relational Database Design

Michael J Hernandez has been an independent relational database consultant specializing relational database design. He has over 20 years of experience in the technology industry, developing database application for a wide variety of clients. He’s been a contributing author to wide variety of magazine columns, white papers, books and periodicals, and is co-author of the best-selling SQL Queries for Mere Mortals. Mike has been a top-rated and noted technical trainer for the government, the military, the private sector and companies throughout the United States. He has spoken at numerous national and international conferences, and has consistently been a top-rated speaker and presenter.

Aside from his technical background, Mike has a diverse set of skills and interests that he also pursues, ranging from the artisitc to the metaphysical. His greatest interest is still the guitar, as he’s been a practicing guitarist for over 40 years and once played professionally for 15 years. He’s a great cook, loves to teach (writing, public speaking, music), has a gift for bad puns, and even reads Tarot cards.

He says he’s never going to retire, per se, but rather just change whatever it is he’s doing whenever he finally gets tired of it and move on to something else that interests him.

Preface
Introduction

I. RELATIONAL DATABASE DESIGN

Chapter 1:  The Relational Database

Chapter 2:  Design Objectives

Chapter 3:  Terminology

II. THE DESIGN PROCESS

Chapter 4:  Conceptual Overview

Chapter 5:  Starting the Process

Chapter 6:  Analyzing the Current Database

Chapter 7:  Establishing Table Structures

Chapter 8:  Keys

Chapter 9:  Field Specifications

Chapter 10: Table Relationships

Chapter 11: Business Rules

Chapter 12: Views

Chapter 13: Reviewing Data Integrity

III. OTHER DATABASE DESIGN ISSUES

Chapter 14: Bad Design-What Not To Do

Chapter 15: Bending or Breaking the Rules

IV. APPENDIXES

Appendix A: Answers to Review Questions

Appendix B: Diagram of the Database Design Process

Appendix C: Design Guidelines

Appendix D: Documentation Forms

Appendix E: Database Design Diagram Symbols

Appendix F: Sample Designs

Appendix G: On Normalization

Appendix H: Recommended Reading

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.