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 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. 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 Learning
Part 1 Background
Chapter 1 Introduction to Databases
Chapter 2 Database Environment
Chapter 3 Database Architectures and the Web
Part 2 The Relational Model and Languages
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
Part 3 Database Analysis and Design
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
Part 4 Methodology
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
Part 5 Selected Database Issues
Chapter 20 Security and Administration
Chapter 21 Professional, Legal, and Ethical Issues in Data Management
Chapter 22 Transaction Management
Chapter 23 Query Processing
Part 6 Distributed DBMSs and Replication
Chapter 24 Distributed DBMSs—Concepts and Design
Chapter 25 Distributed DBMSs—Advanced Concepts
Chapter 26 Replication and Mobile Databases
Part 7 Object DBMSs
Chapter 27 Object-Oriented DBMSs—Concepts and Design
Chapter 28 Object-Oriented DBMSs—Standards and Systems
Part 8 The Web and DBMSs
Chapter 29 Web Technology and DBMSs
Chapter 30 Semistructured Data and XML
Part 9 Business Intelligence
Chapter 31 Data Warehousing Concepts
Chapter 32 Data Warehousing Design
Chapter 33 OLAP
Chapter 34 Data Mining
