Product Cover Image

Database Systems: A Practical Approach to Design, Implementation and Management, CourseSmart eTextbook, 5th Edition

By Thomas M. Connolly, Carolyn E. Begg

Published by Addison-Wesley

Published Date: Feb 26, 2009

More Product Info

Description

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.

Table of Contents

I. Background
1. Introduction to Databases
2. Database Environment
3. Database Architectures and the Web

II. The Relational Model and Languages
4. The Relational model
5. Relational Algebra and Relational Calculus
6. SQL: Data Manipulation
7. SQL: Data Definition
8. Query-By-Example (QBE)

III. Database Analysis and Design
9. Database System Lifecycle
10. Database Analysis and the DreamHome Case Study
11. Entity–Relationship Modeling
12. Enhanced Entity–Relationship Modeling
13. Normalization
14. Advanced Normalization

IV. Methodology
15. Methodology—Conceptual Database Design
16. Methodology—Logical Database Design for Relational Model
17. Methodology—Physical Database Design for Relational Databases
18. Methodology—Monitoring and Tuning the Operational System

V. Selected Database Issues
19. Security and Administration
20. Professional, Legal, and Ethical Issues
21. Transaction Management
22. Query Processing

VI. Distributed DBMSs and Replication
23. Distributed DBMSs—Concepts and Design
24. Distributed DBMSs—Advanced Concepts
25. Replication and Mobile Databases

VII. Object DBMSs
26. Object-Oriented DBMSs—Concepts and Design
27. Object-Oriented DBMSs—Standards and Languages
28. Object-Relational DBMSs

VIII. Web and DBMSs
29. Web Technology and DBMSs
30. Semistructured Data and XML

IX. Business Intelligence Technologies
31. Data Warehousing Concepts
32. Data Warehousing Design
33. OLAP
34. Data Mining

Appendices
A. Users' Requirements Specification for DreamHome Case Study
B. Other Case Studies
C. Alternative Data Modeling Notations
D. Summary of the Database Design Methodology for Relational Databases
E. Introduction to Pyrrho—A Liteweight RDBMS

Web Appendices
F. File Organization and Storage Structures
G. When Is a DBMS Relational?
H. Commercial DBMSs: Access and Oracle
I. Programmatic SQL
J. Estimating Disk Space Requirements
K. Introduction to Object-Orientation
L. Example Web Scripts

Purchase Info ?

With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.

Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.

Buy Access

Database Systems: A Practical Approach to Design, Implementation and Management, CourseSmart eTextbook, 5th Edition
Format: Safari Book

$72.99 | ISBN-13: 978-0-13-607645-2