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

Autorentext

Thomas M. Connolly is the Head of the Computing and Information Systems division at the University of Paisley. Carolyn E. Begg is a lecturer at the University of Paisley, with research interests in Information Systems, Database Management Systems, and Decision Support Systems within medicine

Klappentext

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

Zusammenfassung
Teach database theory with the bestselling text on the subject Database Systems: A Practical Approach to Design, Implementation, and Management introduces the theory behind databases in a concise yet comprehensive manner. Designed for undergraduate courses, the text is accessible for non-technical readers. This title comes with a Companion Website.

Inhalt

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