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 building databases than just knowing SQL. Database design is the art of transforming 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