Front Cover -- Database Modeling and Design -- Copyright -- Dedication -- Contents -- Preface -- Organization -- Typographical Conventions -- Acknowledgments -- Solutions Manual -- About the Authors -- Chapter 1: Introduction -- Data and Database Management -- Database Life Cycle -- Conceptual Data Modeling -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Chapter 2: The Entity-Relationship Model -- Fundamental ER Constructs -- Advanced ER Constructs -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Chapter 3: The Unified Modeling Language -- Class Diagrams -- Activity Diagrams -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Chapter 4: Requirements Analysis and Conceptual Data Modeling -- Introduction -- Requirements Analysis -- Conceptual Data Modeling -- View Integration -- Entity Clustering for ER Models -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Chapter 5: Transforming the Conceptual Data Model to SQL -- Transformation Rules and SQL Constructs -- Transformation Steps -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Chapter 6: Normalization -- Fundamentals of Normalization -- The Design of Normalized Tables: A Simple Example -- Normalization of Candidate Tables Derived from ER Diagrams -- Determining the Minimum Set of 3NF Tables -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Chapter 7: An Example of Logical Database Design -- Requirements Specification -- Logical Design -- Summary -- Tips and Insights for Database Professionals -- Chapter 8: Object-Relational Design -- Object Orientation -- Object-Oriented Databases -- Object-Relational Databases -- Summary -- Tips and Insights for Database Professionals -- Literature Summary.

Chapter 9: XML and Web Databases -- XML -- XML Design -- Web-Based Applications -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Chapter 10: Business Intelligence -- Data Warehousing -- Online Analytical Processing -- Data Mining -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Chapter 11: CASE Tools for Logical Database Design -- Introduction to the CASE Tools -- Key Capabilities to Watch for -- The Basics -- Generating a Database from a Design -- Database Support -- Collaborative Support -- Distributed Development -- Application Life Cycle Tooling Integration -- Design Compliance Checking -- Reporting -- Modeling a Data Warehouse -- Semistructured Data-XML -- Summary -- Tips and Insights for Database Professionals -- Literature Summary -- Appendix: The Basics of SQL -- SQL Names and Operators -- Data Definition Language -- Data Manipulation Language -- References -- References -- Exercises -- ER and UML Conceptual Data Modeling -- Conceptual Data Modeling and Integration -- Transformation of the Conceptual Model to SQL -- Normalization and Minimum Set of Tables -- Logical Database Design (Generic Problem) -- OLAP -- Solutions to Selected Exercises -- Glossary -- Index -- Bonus Chapter Opener -- Chapter 3: Query Optimization and Plan Selection -- 3.1. Query Processing and Optimization -- 3.2. Useful Optimization Features in Database Systems -- 3.2.1 Query Transformation or Rewrite -- 3.2.2 Query Execution Plan Viewing -- 3.2.3 Histograms -- 3.2.4 Query Execution Plan Hints -- 3.2.5 Optimization Depth -- 3.3.1 Example Query 3.1 -- 3.4. Query Execution Plan Development -- 3.4.1 Transformation Rules for QueryExecution Plans -- 3.4.2 Query Execution Plan RestructuringAlgorithm -- 3.5. Selectivity Factors, Table Size, and Query Cost Estimation.

3.5.1 Estimating Selectivity Factor for a SelectionOperation or Predicate -- 3.5.2 Histograms -- 3.5.3 Estimating the Selectivity Factor for a Join -- 3.5.4 Example Query 3.2 -- 3.5.5 Example Estimations of Query ExecutionPlan Table Sizes -- 3.6. Summary -- Tips and Insights for DatabaseProfessionals -- 3.7 Literature Summary -- Appendix A: A Simple Performance Model for Databases -- A.1. I/O Time Cost-Individual Block Access -- A.2. I/O Time Cost-Table Scans and Sorts -- A.3. Network Time Delays -- A.4. CPU Time Delays -- References.