Database Systems, 4th Edition

Customers who bought this, also bought: Macromedia Dreamweaver 8 with ASP, ColdFusion, and PHP : Training from the Source (Paperback) Head First Java, 2nd Edition UML for the IT Business Analyst: A Practical Guide to Object-Oriented Requirements Gathering (Paperback) Beginning SQL Programming in Visual Basic.NET Update Edition for VB.NET 2003 (ISBN: w/ 5-CD VB.Net 2003 Software set) Database Systems Concepts (5th Edition) Applying UML and Patterns: An Introduction to Object-Oriented Analysis and Design and Iterative Development (3rd Edition) Data Structures and Program Design In C - 2nd edition Learning SQL on SQL Server 2005 Absolute Java: International Edition, 3rd Edition

by: Thomas Connolly Carolyn Begg

Notify me when in stock

On-line Price: $123.95 (includes GST) Paperback package 1424 13%Off Retail Price You save: $19.00 Usually ships within 3-5 business days. We will advise you if a delay or price change is expected.	Retail Price: $142.95 Publisher: ADDISON-WESLEY,30.06.04 Category: INFORMATION TECHNOLOGY Level: I/A ISBN: 0321210255 ISBN13: 9780321210258
Add to Shopping Cart

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 reading Database 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.

      New To This Edition

Thorough update of later chapters covering object oriented databases, web databases, XML, data warehousing, data mining.

Features greater interaction on the companion Web site, including multiple choice questions for each chapter.

Includes access to an online tool that allows students to run database queries against their own database, and a downloadabe ER editor that utilizes the UML notation and allows students to create their own ER diagrams.

More links to web resources. New end of chapter exercises and exam questions.

Oracle 9i will be packaged with the book.

      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 (www.booksites.net/connolly) with:

          full implementations of case studies used in the book

lab guides for Access and Oracle

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

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 (QBE).

        8. Commercial DBMSs: 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.

      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.

      20. Transaction management.

      21. Query processing.

      22. Programming SQL.

      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. Introduction to Object DBMSs.

      27. Object-oriented DBMSs - concepts and design.

      28. Object-oriented DBMSs - standards and languages.

      29. Object-relational DBMSs.

      VIII. WEB AND DBMSs.

  30. Web technology and DBMSs.

      31. Semistructured data and XML.

      IX. BUSINESS INTELLIGENCE (OR DECISION SUPPORT).

  32. Data warehousing concepts.

      33. Data warehousing design.

      34. OLAP.

      35. Data mining.

      APPENDICES.

  A. Users' requirements specification for Dreamhome case study.

      B. Other case studies.

      C. File organization and storage structures.

      D. When is a DBMS relational?

      E. Programmatic SQL.

      F. Alternative data modeling notations.

      G. Summary of the database design methodology for relational databases.

      H. Estimating disk space requirements.

      I. Example web scripts.