Chapter 1 Introduction to Databases Chapter 2 Database Environment Chapter 3 Database Architectures and the Web Chapter 4 The Relational Model Chapter 5 Relational Algebra and Relational Calculus Chapter 6 SQL: Data Manipulation Chapter 7 SQL: Data Definition Chapter 8 Advanced SQL Chapter 9 Object-Relational DBMSs Chapter 10 Database System Development Lifecycle Chapter 11 Database Analysis and the DreamHome Case Study Chapter 12 Entity-Relationship Modeling Chapter 13 Enhanced Entity-Relationship Modeling Chapter 14 Normalization Chapter 15 Advanced Normalization Chapter 16 Methodology-Conceptual Database Design Chapter 17 Methodology-Logical Database Design for the Relational Model Chapter 18 Methodology-Physical Database Design for Relational Databases Chapter 19 Methodology-Monitoring and Tuning the Operational System Chapter 20 Security and Administration Chapter 21 Professional, Legal, and Ethical Issues in Data Management Chapter 22 Transaction Management Chapter 23 Query Processing Chapter 24 Distributed DBMSs-Concepts and Design Chapter 25 Distributed DBMSs-Advanced Concepts Chapter 26 Replication and Mobile Databases Chapter 27 Object-Oriented DBMSs-Concepts and Design Chapter 28 Object-Oriented DBMSs-Standards and Systems Chapter 29 Web Technology and DBMSs Chapter 30 Semistructured Data and XML Chapter 31 Data Warehousing Concepts Chapter 32 Data Warehousing Design Chapter 33 OLAP Chapter 34 Data Mining
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 its comprehensive coverage, this book can also be used as a reference for IT professionals. This 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. Teaching and Learning Experience This program presents a better teaching and learning experience-for you and your students. It provides: Database Design Methodology that can be Used by Both Technical and Non-technical Readers ; A Comprehensive Introduction to the Theory behind Databases ; A Clear Presentation that Supports LearningA Comprehensive Introduction to the Theory behind Databases Extended chapter on database architectures and the Web, covering cloud computing New Section on Data Warehousing and Temporal Databases Updated treatment to cover the latest version of the SQL standard, which was released late 2011 (SQL:2011) Extended chapter on replication and mobile databases Updated chapters on Web-DBMS integration and XML Extended treatment of XML, SPARQL, XQuery 1.0 and XPath 2.0 (including the new XQuery Update facility), and the new SQL:2011 SQL/XML standard Coverage updated to Oracle 11gA Clear Introduction to the Theory behind Databases New review questions and exercises at the end of chapters allow readers to test their understanding