9780321523068

Database Systems A Practical Approach to Design, Implementation and Management

by ;
  • ISBN13:

    9780321523068

  • ISBN10:

    0321523067

  • Edition: 5th
  • Format: Paperback
  • Copyright: 2/24/2009
  • Publisher: Pearson
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $192.80

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.

Rewards Program

Customer Reviews

comprehensive database textbook July 6, 2011
by
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!
Flag Review
Please provide a brief explanation for why you are flagging this review:
Submit
Your submission has been received. We will inspect this review as soon as possible. Thank you for your input!
Database Systems A Practical Approach to Design, Implementation and Management: 5 out of 5 stars based on 1 user reviews.

Write a Review