Harrington Relational Database Design Clearly Explained

2. Auflage 2002
ISBN: 978-0-08-051606-6
Verlag: Elsevier Science & Techn.
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 416 Seiten, Web PDF

Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you'll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS.

Supporting the book's step-by-step instruction are three case studies illustrating the planning, analysis, and design steps involved in arriving at a sound design. These real-world examples include object-relational design techniques, which are addressed in greater detail in a new chapter devoted entirely to this timely subject.

* Concepts you need to master to put the book's practical instruction to work.
* Methods for tailoring your design to the environment in which the database will run and the uses to which it will be put.
* Design approaches that ensure data accuracy and consistency.
* Examples of how design can inhibit or boost database application performance.
* Object-relational design techniques, benefits, and examples.
* Instructions on how to choose and use a normalization technique.
* Guidelines for understanding and applying Codd's rules.
* Tools to implement a relational design using SQL.
* Techniques for using CASE tools for database design.

Autoren/Hrsg.

Harrington, Jan L.

Inhaltsverzeichnis

1;Front Cover ;1
2;Relational Database Design Clearly Explained;4
3;Copyright Page ;5
4;Contents ;6
5;Preface to the Second Edition;14
5.1;What You Need to Know;16
5.2;Acknowledgments;16
6;Part One: Theory;19
6.1;Chapter 1. Introduction;21
6.1.1;Effects of Poor Database Design;22
6.1.2;What You Will Find in This Book;27
6.2;Chapter 2. Entities and Data Relationships;29
6.2.1;Entities and Their Attributes;30
6.2.2;Domains;38
6.2.3;Basic Data Relationships;41
6.2.4;Dealing with Many-to-Many Relationships;51
6.2.5;Relationships and Business Rules;55
6.2.6;Data Modeling versus Data Flow;57
6.2.7;Schemas;61
6.2.8;For Further Reading;62
6.3;Chapter 3. Historical Antecedents;65
6.3.1;File Processing Systems;66
6.3.2;The Hierarchical Data Model;72
6.3.3;The Simple Network Data Model;77
6.3.4;The Complex Network Data Model;83
6.4;Chapter 4. The Relational Data Model;91
6.4.1;Understanding Relations;92
6.4.2;Primary Keys ;95
6.4.3;Representing Data Relationships;100
6.4.4;Views;104
6.4.5;The Data Dictionary;106
6.4.6;A Bit of History;108
6.4.7;For Further Reading;110
6.5;Chapter 5. Normalization;111
6.5.1;Translating an ER Diagram into Relations;112
6.5.2;Normal Forms;113
6.5.3;First Normal Form;114
6.5.4;Second Normal Form;120
6.5.5;Third Normal Form;124
6.5.6;Boyce–Codd Normal Form;126
6.5.7;Fourth Normal Form;128
6.5.8;Normalized Relations and Database Performance;130
6.5.9;For Further Reading;137
6.6;Chapter 6. Database Structure and Performance Tuning;139
6.6.1;Indexing;140
6.6.2;Clustering;142
6.6.3;Partitioning;144
6.6.4;For Further Reference;146
6.7;Chapter 7. Codd's Rules;147
6.7.1;Rule 1: The Information Rule;148
6.7.2;Rule 2: The Guaranteed Access Rule;150
6.7.3;Rule 3: Systematic Treatment of Null Values;151
6.7.4;Rule 4: Dynamic Online Catalog Based on the Relational Model;152
6.7.5;Rule 5: The Comprehensive Data Sublanguage Rule;153
6.7.6;Rule 6: The View Updating Rule;154
6.7.7;Rule 7: High-Level Insert, Update, and Delete;155
6.7.8;Rule 8: Physical Data Independence;156
6.7.9;Rule 9: Logical Data Independence;157
6.7.10;Rule 10: Integrity Independence;157
6.7.11;Rule 11: Distribution Independence;159
6.7.12;Rule 12: Nonsubversion Rule;160
6.8;Chapter 8. Integrating Objects;161
6.8.1;An Introduction to Object-Oriented Concepts;162
6.8.2;Integrating Objects into a Relational Database;184
6.8.3;ER Diagrams for Object-Relational Designs;185
6.8.4;For Further Reading;190
7;Part Two: Practice;193
7.1;Chapter 9. Using SQL to Implement a Relational Design;195
7.1.1;Database Object Hierarchy;196
7.1.2;Schemas;199
7.1.3;Domains;201
7.1.4;Tables;202
7.1.5;Views;216
7.1.6;Temporary Tables;219
7.1.7;Creating Indexes;222
7.1.8;Modifying Database Elements;223
7.1.9;Deleting Database Elements;227
7.1.10;Granting and Revoking Access Rights;227
7.1.11;Object-Relational Extensions;231
7.2;Chapter 10. Using CASE Tools for Database Design;233
7.2.1;CASE Capabilities;234
7.2.2;ER Diagram Reports;236
7.2.3;Data Flow Diagrams;238
7.2.4;The Data Dictionary;240
7.2.5;Code Generation;243
7.2.6;Sample Input and Output Designs;246
7.2.7;The Drawing Environment;247
7.2.8;For Further Reading;248
7.3;Chapter 11. Database Design Case Study #1: Mighty-Mite Motors;249
7.3.1;Corporate Overview;250
7.3.2;Designing the Database;269
7.3.3;The Object-Relational Design;286
7.4;Chapter 12: Database Design Case Study #2: East Coast Aquarium;299
7.4.1;Organizational Overview;300
7.4.2;The Volunteers Database;308
7.4.3;The Animal Tracking Database;319
7.4.4;The Object-Relational Design;334
7.5;Chapter 13. Database Design Case Study #3: Independent Intelligence Agency;339
7.5.1;Organizational Overview;340
7.5.2;Designing the Database;351
7.5.3;The Object-Relational Design;373
8;Glossary;393
9;Index;405