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

Published by Pearson United Kingdom (September 26, 2014) © 2015
  • Thomas Connolly
  • Carolyn Begg

Title overview

help your students grasp database theory with the bestselling text on the subject

Database Systems: A Practical Approach to Design, Implementation, and Management, 6th edition, introduces your students to the theory behind databases in a concise yet comprehensive manner.

The text adopts a simple approach, making it accessible for non-technical readers and preventing students getting confused. A realistic worked example teaches students how to apply their knowledge and gradually develops critical thinking skills.

Designed for one or two-term undergraduate courses in database management or database design, this book promotes a positive learning experience.

This title also has a Companion Website.

Hallmark features of this title

A Methodology that can be used by Technical and Non-technical Readers

  • The design methodology is divided into three phases based on the widely accepted Entity—Relationship model: conceptual, logical, and physical.
  • The methodology in each phase is presented as a series of steps for the inexperienced designer, and a checklist for the experienced designer.
  • A step-by-step methodology for physical database design, covers mapping of design to implementation. The integrated case study shows how to use the methodology.

A Clear Presentation Supports Learning

  • Definitions are highlighted, chapter objectives are clearly stated, and chapters are neatly summarized.
  • Examples and diagrams throughout each chapter illustrate the main concepts.

New and updated features of this edition

This edition has been revised to present students with a concise introduction to the theory behind databases.

Updates include:

Additional updated content from the previous edition.

  • An extended chapter on database architectures and the Web, covering cloud computing.
  • A new Section on Data Warehousing and Temporal Databases.
  • Updated text to cover the latest version of the SQL standard, which was released late 2011 (SQL:2011).
  • An 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 11g.

Extra features to support your students' learning.

  • New review questions and exercises at the end of chapters allow readers to test their understanding.

Key features

Features of Pearson eText for the 6th Edition

Extend learning beyond the classroom with Pearson eText – an easy-to-use digital textbook.

Optimise study time
  • Find it fast. Enhanced search makes it easy to find a key term or topic to study. Students can also search videos, images, and their own notes.
  • Get organised and get results. Students can customise how they study and add their own notes, bookmarks, and highlights directly in their eText.
  • Study in a flash. Students can use pre-built flashcards or create their own to study how they like.
Meet students where they are
  • Read online or offline. With the mobile app, you and your students can access your eText anytime, even offline.
  • Listen anywhere. Learners can listen to the audio version of their eText for most titles, whether at home or on the go.
  • Watch and learn. Videos and animations within the eText bring tricky concepts to life (available in selected titles).

Find out more about Pearson eText.

Table of contents

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

Author bios

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

Loading...Loading...Loading...