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

Series
Addison-Wesley
Author
Thomas Connolly / Carolyn Begg  
Publisher
Addison-Wesley
Cover
Softcover
Edition
4
Language
English
Total pages
1424
Pub.-date
May 2004
ISBN13
9780321210258
ISBN
0321210255
Related Titles



Description

For undergraduate courses covering databases for the following departments; Computer Science, Business IT, Management Information Systems, MSc conversion courses.

Over 200,000 people have been grounded in good database design practice by readingDatabase Systems. The new edition of this best-seller brings it up to date with the latest developments in database technology and builds on the clear, accessible approach that has contributed to the success of previous editions.

A clear introduction to design, implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable complete reference for database students and professionals alike.

Features

  • Complex subjects are clearly explained using running case studies throughout the book – brings the subject to life by showing students how each topic actually works in real world.
  • Database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described with an example of how it works in practice. Students are able to understand and grasp each topic fully before moving on to the others.
  • SQL is comprehensively covered in three tutorial style chapters – helps students fully understand how to use it before attempting to apply it to real databases.
  • Full discussion of distributed, object-oriented, and object-relational DBMSs.

Companion website with:

  • full implementations of case studies used in the book
  • lab guide for Access
  • tutorials on selected chapters
  • sample databases
  • extra case study
  • practical exercises for labwork
  • powerpoint slides
  • teaching hints and suggestions
  • solutions to exercises and tutorials

 

 

Table of Contents

Preface

Part 1 Background

1 Introduction to Databases

2 Database Environment

Part 2 The Relational Model and Languages

3 The Relational Model

4 Relational Algebra and Relational Calculus

5 SQL: Data Manipulation

6 SQL: Data Definition

7 Query-By-Example

8 Commercial RDBMSs: Office Access and Oracle

Part 3 Database Analysis and Design Techniques

9 Database Planning, Design, and Administration

10 Fact-Finding Techniques

11 Entity-Relationship Modeling

12 Enhanced Entity-Relationship Modeling

13 Normalization

14 Advanced Normalization

Part 4 Methodology

15 Methodology - Conceptual Database Design

16 Methodology - Logical Database Design for the Relational Model

17 Methodology - Physical Database Design for Relational Databases

18 Methodology - Monitoring and Tuning the Operational System

Part 5 Selected Database Issues

19 Security

20 Transaction Management

21 Query Processing

Part 6 Distributed DBMSs and Replication

22 Distributed DBMSs - Concepts and Design

23 Distributed DBMSs - Advanced Concepts

24 Replication and Mobile Databases

Part 7 Object DBMSs

25 Introduction to Object DBMSs

26 Object-Oriented DBMSs - Concepts

27 Object-Oriented DBMSs - Standards and Systems

28 Object-Relational DBMSs

Part 8 Web and DBMSs

29 Web Technology and DBMSs

30 Semistructured Data and XML

Part 9 Business Intelligence

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 File Organizations and Indexes

D When is a DBMS Relational?

E Programmatic SQL

F Alternative ER Modeling Notations

G Summary of the Database Design Methodology for Relational Databases

H Estimating disk space requirements (web only)

I Example web scripts (web only)

References

Further Reading

Index

 

 

 

 

Back Cover

Over 200,000 people have been grounded in good database design practice by readingDatabase Systems. The new edition of this bestseller brings it up to date with the latest developments in database technology and builds on the clear, accessible approach that has contributed to the success of previous editions.

A clear introduction to design, implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable complete reference for database students and professionals alike

Features

  • Complex subjects are clearly explained using running case studies throughout the book.
  • Database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described with an example of how it works in practice.
  • SQL is comprehensively covered in three tutorial-style chapters.
  • Distributed, object-oriented, and object-relational DBMSs are fully discussed.

Check out the web site at www.booksites.net/connbegg, for full implementations of the case studies, lab guides for Access and Oracle, and additional student support.

New! For the fourth edition

  • Extended treatment of XML, OLAP and data mining.
  • Coverage of updated standards including SQL:2003, W3C (XPath and

XQuery), and OMG.

  • Now covers Oracle9i and Microsoft Office Access 2003.

Both Thomas Connolly and Carolyn Begg have experience of database design in industry, and now apply this in their teaching and research at the University of Paisley in Scotland.

This book comes with a free six-month subscription to Database Place, an online tutorial that helps readers master the key concepts of database systems.  Log on at www.aw.com/databaseplace.

 

 


Instructor Resources