Database Systems A Practical Approach to Design, Implementation and Management

by ;
Edition: 5th
Format: Paperback
Pub. Date: 2009-02-24
Publisher(s): Pearson
List Price: $206.28

Rent Textbook

Select for Price
There was a problem. Please try again later.

New Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Customer Reviews

comprehensive database textbook  July 6, 2011
by
Rating StarRating StarRating StarRating StarRating Star

I used this textbook to teach a course in Database Systems. It 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. This textbook is for someone who, whether student or practitioner, wants a completely thorough treatment of the topic of databases, with virtually no topic left out, and with enough detail and examples to apply the techniques in practice. This textbook can also be used as a reference for IT professionals. I needed this textbook for a class. I got it at a great price and it arrived on time! Highly recommended!






Database Systems A Practical Approach to Design, Implementation and Management: 5 out of 5 stars based on 1 user reviews.

Summary

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.

The Fifth Edition brings Web and legal issues to the fore in two new chapters, Database Architectures and the Web and Professional, Legal, and Ethical Issues. Students are exposed not only to the foundational theory of databases but also to the most recent developments in the field.

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 comprehensive coverage, this book can also be used as a reference for IT professionals.

-Database design methodology is explicitly divided into three phases based on the widely accepted Entity–Relationship model: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice.

-A clear and easy-to-understand presentation supports student learning and retention: definitions are highlighted clearly, chapter objectives are stated succinctly, and chapters are summarized completely.

-Numerous examples and diagrams throughout each chapter illustrate the main concepts, and a realistic case study is integrated throughout the book.

-Extensive treatment of SQL in three tutorial style chapters, covering both interactive and embedded SQL.

-Extensive treatment of the Web as an emerging platform for database applications with many code samples for accessing databases from the Web including JDBC™, SQLJ, ASP, ISP, and Oracle® PSP.

Author Biography

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.

Table of Contents

Background
Introduction to Databases
Database Environment
Database Architectures and the Web
The Relational Model and Languages
The Relational model
Relational Algebra and Relational Calculus
SQL: Data Manipulation
SQL: Data Definition
Query-By-Example (QBE)
Database Analysis and Design
Database System Lifecycle
Database Analysis and the DreamHome: Case Study
Entity-Relationship Modeling
Enhanced Entity-Relationship Modeling
Normalization
Advanced Normalization
Methodology
Methodology-Conceptual Database Design
Methodology-Logical Database Design for Relational Model
Methodology-Physical Database Design for Relational Databases
Methodology-Monitoring and Tuning the Operational System
Selected Database Issues
Security and Administration
Professional, Legal, and Ethical Issues
Transaction Management
Query Processing
Distributed DBMSs and Replication
Distributed DBMSs-Concepts and Design
Distributed DBMSs-Advanced Concepts
Replication and Mobile Databases
Object DBMSs
Object-Oriented DBMSs-Concepts and Design
Object-Oriented DBMSs-Standards and Languages
Object-Relational DBMSs
Web and DBMSs
Web Technology and DBMSs
Semistructured Data and XML
Business Intelligence Technologies
Data Warehousing Concepts
Data Warehousing Design
OLAP
Data Mining
Appendices
Users'
Other Case Studies
Alternative Data Modeling Notations
Summary of the Database Design Methodology for Relational Databases
Introduction to Pyrrho-A Liteweight RDBMS
Web Appendices
File Organization and Storage Structures
When Is a DBMS Relational?
Commercial DBMSs: Access and Oracle
Programmatic SQL
Estimating Disk Space Requirements
Introduction to Object-Orientation
Example Web Scripts
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.