Includes bibliographical references and index.

Part One Background 3 -- 1 Introduction to Databases 3 -- 2 Database Environment 38 -- 3 The Relational Model 71 -- 4 Database Planning, Design, and Administration 111 -- Part Two Methodology -- 5 Entity - Relationship Modeling 149 -- 6 Normalization 191 -- 7 Methodology - Conceptual Database Design 225 -- 8 Methodology - Logical Database Design for Relational Model 242 -- 9 Methodology - Physical Database Design for Relational Databases 268 -- 10 Conceptual Database Design Methodology - Worked Example 305 -- 11 Logical Database DesignMethodology - Worked Example 327 -- 12 Physical Database DEsign Methodology - Worked Example 352 -- Part Three Database Languages -- 13 SQL 383 -- 14 Advanced SQL 440 -- 15 Query - By - Example (QBE) 504 -- Part Four Selected Database Issues -- 16 Security 531 -- 17 Transaction Management 557 -- 18 Query Processing 603 -- Part Five Current Trends -- 19 Distributed DBMSs - Concepts and Design 645 -- 20 Distributed DBMSs - Advanced Concepts 687 -- 21 Introduction to Object DBMSs 728 -- 22 Object - Oriented DBMs 754 -- 23 Object - Relational DBMSs 800 -- Part Six Future Trends -- 24 Web Technology and DBMs 855 -- 25 Data Warehousing 912 -- 26 OLAP and Data Mining 948

"This book is ideal for a one- or two-term course in database management or database design in an undergraduate or graduate level course. With comprehensive coverage, this book can also be used as a reference for IT professionals. This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases -- conceptual, logical, and physical database design." -- Provided by publisher