Addison Wesley Professional, 2005. — 384 p. — ISBN: 0-321-29093-3.
The book concludes with comprehensive, expert guidance on designing databases for maximum usability. This book will teach you how to:
Understand relational database models, structures, relationships, and data integrity principles
Define database system goals, criteria, scope, and work processes
Construct accurate conceptual models: relationships, entities, domain analysis, and normalization
Build efficient, secure database schema
Master the elements of OLAP design: fact tables, dimension tables, snowflaking, and more
Architect and construct easy, efficient interfaces for querying and reporting
Learn from practice examples based on Microsoft's Northwind sample database