Skip To Page Navigation|Skip To Page Content

Addison-Wesley / Prentice Hall

Computer Science

My Instructor Resource Center : Log in or request access

Database Systems: A Practical Approach to Design, Implementation, and Management, 3/E
Thomas Connolly, University of Paisley
Carolyn Begg, University of Paisley

ISBN-10: 0321181050
ISBN-13: 9780321181053

Publisher: Addison-Wesley
Copyright: 2002
Format: Paper Package
Published: 12/04/2002

Database Systems' practical, hands-on approach makes it uniquely suited to providing a strong foundation in good database design practice. 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. 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 contributed to the success of previous editions.

A realistic case study integrated throughout the book enable complex subjects to be explained in the context of one understandable example, while three additional case studies allow readers to work through examples by themselves. Clearly stated chapter objectives and summaries guide the reader, highlighted key definitions and numerous worked examples illustrate the concepts, and review questions and exercises reinforce the material covered in each chapter.

NEW! All new copies come with free access to Addison-Wesley's Database Place. Database Place helps students master the key concepts of all database courses. It includes online tutorials that help students with their mastery of Conceptual Data Modeling using the Entity Relationship (ER) Data Model, Relational Data Model, Relational Algebra, SQL and Data Normalization. Each tutorial asks students to solve problems (such as writing an SQL query, drawing an ER diagram or normalize a relation), and then provides useful feedback based on the student's solution.

NEW! Use of UML notation for ER diagrams.

NEW! New chapter on the relational algebra and relational calculus.

NEW! Chapter on fact-finding techniques as a step before where the methodology begins.

NEW! Chapter on Access and Oracle DBMSs, illustrating the difference between the two systems. Many of the subsequent chapters discuss how these systems implement the topics being covers.

NEW! Chapters on semistructured data, its relationship to XML, and query languages for XML.

NEW! Chapter on data warehouse design using dimensionality modeling.

NEW! Introduction of colour to highlight the text when necessary and improve navigation through the book.

NEW! Additional Web resources at www.booksites.net, such as full implementation of the case studies, and lab notes for Access and Oracle.

Database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice.

Extensive treatment of SQL in three tutorial style chapters.

Comprehensive introduction to data warehousing, OLAP, and data mining.

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's PSP.

Preface.

I. BACKGROUND.

1. Introduction to Databases.

2. Database Environment.

II. 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: Access and Oracle.

III. 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.

IV. METHODOLOGY.

14. Methodology - Conceptual Database Design.

15. Methodology - Logical Database Design for the Relational Model.

16. Methodology - Physical Database Design for Relational Databases.

17. Methodology - Monitoring and Tuning the Operational System.

V. SELECTED DATABASE ISSUES.

18. Security.

19. Transaction Management.

20. Query Processing.

21. Programmatic SQL.

VI. CURRENT TRENDS.

22. Distributed DBMSs - Concepts and Design.

23. Distributed DBMSs - Advanced Concepts.

24. Introduction to Object DBMSs.

25. Object-Oriented DBMSs - Concepts and Design.

26. Object-Oriented DBMSs - Standards and Systems.

27. Object-Relational DBMSs.

VII. EMERGING TRENDS.

28. Web Technology and DBMSs.

29. Semistructured Data and XML.

30. Data Warehousing Concepts.

31. Data Warehousing Design.

32. OLAP and Data Mining.

APPENDICES.

A. Users' Requirements Specification for DreamHome Case Study.

B. Other Case Studies.

C. File Organization and Storage Structures.

D. When is DBMS Relational?

E. Alternative ER Modeling Notations.

F. Summary of the Database Design Methodology for Relational Databases.

G. Estimating Disk Space Requirements.

H. Example Web Scripts.

References.

Further Reading.

Index.

Database Systems & Design (Computer Science)
Database Systems: Advanced Topics (Computer Science)

Database Systems: A Practical Approach to Design, Implementation and Management, 5/E
Connolly & Begg
©2010 | Addison-Wesley | Paper; 1400 pp | Instock
ISBN-10: 0321523067 | ISBN-13: 9780321523068
Net price: $93.75 (What's this?)Brief 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.
Instructor's Solutions Manual for Database Systems: A Practical Approach to Design, Implementation and Management, 5/E
Connolly & Begg
©2009 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321523075 | ISBN-13: 9780321523075
Powerpoint Slides for Database Systems: A Practical Approach to Design, Implementation and Management, 5/E
Connolly & Begg
©2009 | Addison-Wesley | Online Study Guide | Instock
ISBN-10: 0321523083 | ISBN-13: 9780321523082

DatabasePlace Website
Addison Wesley Higher Education
©2003 | Addison-Wesley | Website | Instock
ISBN-10: 0321160088 | ISBN-13: 9780321160089
Online purchase price: $18.00

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.