Database Systems: A Practical Approach to Design, Implementation, and Management, Global Edition

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
• Database Environment
• Database Architectures and the Web

Part 2 The Relational Model and Languages

• Chapter 4 The Rational 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 Standard 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

Appendices References Further Reading Index