CONTETNS Part 1 Introduction and Conceptual Modeling 1 Databases and Database Users 2 Database System Concepts and Architecture 29 3 Data Modeling Using the Entity-Relationship (ER) Model 4 The Enhanced Entity-Relationship (EER) Model 103 Part 2 Relational Model: Concepts, Constraints, Languages, Design, and Programming 5 The Relational Data Model and Relational Database Constraints 145 6 The Relational Algebra and Relational Calculus 173 7 Relational Database Design by ER- and EER-to-Relational Mapping 225 8 SQL-99: Schema Definition, Constraints, Queries, and Views 243 9 Introduction to SQL Programming Techniques 301 Part 3Database Design Theory and Methodology 10 Functional Dependencies and Normalization for Relational Databases 337 11 Relational Database Design Algorithms and Further Dependencies 381 12 Practical Database Design Methodology and Use of UML Diagrams 415 Part 4 Data Storage, indexing, Query Processing, and Physical Design 13 Disk Storage, Basic File Structures, and Hashing 465 14 Indexing Structures for Files 513 15 Algorithms for Query Processing and Optimization 551 16 Physical Database Design and Tuning 595 Part 5 Transaction Processing Concepts 17 Introduction to Transaction Processing Concepts and Theory 611 18 Concurrency Control Techniques 643 19 Database Recovery Techniques 671 Part 6 Object and Object-Relational Databases 2O Concepts for Object Databases 701 21 Object Database Standards, Languages, and Design 729 22 Object-Relational and Extended-Relational Systems 765 Part 7 Further Topics: Security, Advanced Modeling, and Distribution 23 Database Security797 24 Enhanced Data Models for Advanced Applications 825 25 Distributed Databases and Client-Server Architectures 875 Part 8 Emerging Technologies o 26 Web Database Programming Using PHP 915 27 XML: Extensible Markup Language 939 28 Data Mining Concepts 963 29 Overview of Data Warehousing and OLAP 995 3O Emerging Database Technologies and Applications 1013 appendix A Alternative Diagrammatic Notations for ER Models 1055 appendix D Parameters of Disks 1059 appendix C Overview of the QBE Language 1063 appendix D Overview of the Hierarchical Data Model (located on the Companion Website at www.pearsoned.co.in/ramezeliDasri) appendix E Overview of the Network Data Model (located on the Comp'anion Website at www. pearsoned. co. in/ramezelmasri) Selected Bibliography 1071 Index 1101