This book provides a practical and proven approach to designing relational databases. It contains two complementary design methodologies: logical data modeling and relational database design. The design methodologies are independent of product-specific implementations and have been applied to numerous relational product environments.
Why a Handbook of Relational Database Design?
Introduction to Logical Data Modeling.
Relational Concepts and SQL.
Introduction to Relational Database Design.
Build Skeletal User Views.
Add Keys to User Views.
Add Detail to User Views.
Validate User Views through Normalization.
Determine Additional Attribute Business Rules.
Integrate User Views.
Translate the Logical Data Structure.
Translate the Logical Data Integrity.
Tune by Establishing Storage-Related Access Mechanisms.
Tune by Adding Indexes.
Tune by Introducing Controlled Data Redundancy.
Tune by Redefining the Relational Database Structure.
Special Design Challenges.
Index of Design Rules.