A Sane Approach to Database Design

Learn how to create an accurate, efficient, maintainable database that can be implemented on any modern platform.

There's more to database design than "knowing SQL". Database design is the art of translating real-world requirements into an information model that can be implemented with a relational database. Which particular database product you use is not important. The concepts are the same.

This book presents a step-by-step guide to building a database. Topics include:

• Requirements gathering
• Introduction to SQL
• The model sequence
• Entities, relationships, and attributes
• Keys and indexes
• Entity-Relationship Diagrams
• Naming
• Normalization
• Implementation
• Breaking the rules

The author has been building databases for 28 years. He has developed systems for manufacturing, marketing, merchandising, medical, and military organizations, as an employee and as a consultant. He lives in Michigan with his teenage daughter.