Database Systems, International Edition

Description

This new international version of Database Systems maintains its engaging writing style and brevity, its unique balance between theory and practice and its wealth of examples throughout the text, inspiring student-friendly learning at its best.

This new international version includes new chapters on Relational Algebra and Physical Database Design, and UML modelling notation. It has been updated with all the latest developments and technologies and incorporates a generous number of localised and motivating business vignettes that tie the concepts to real-life situations.

CONTENTS:

PART ONE: DATABASE CONCEPTS

1. Database Systems

2. Data Models

3. The Relational Database Model

4. Relational Algebra

PART TWO: DESIGN CONCEPTS

5. Entity Relationship Modelling

6. Advanced Data Modelling

7. Normalisation of Database Tables

PART THREE: SQL

8. Introduction to SQL

9. Advanced SQL

PART FOUR: DATABASE DESIGN AND IMPLEMENTATION

10. Overview of Database Design

11. Conceptual, Logical and Physical Database Design

PART FIVE: DATABASE TRANSACTIONS AND PERFORMANCE TRAINING

12. Transaction Management and Concurrency Control

13. Database Performance Tuning and Query Optimisation

PART SIX: CONCEPTS OF LARGE SCALE DATABASE SYSTEMS

14. Distributed Database Management Systems

15. The Data Warehouse

16. Database Connectivity and Web Development

APPENDICES

Appendix A: Designing Databases with Visio Professional: A Tutorial

Appendix B: The University Lab: Conceptual Design and Verification

Appendix C: The University Lab: Logical and Physical Database Design and Implementation

Appendix D: Converting an ER Model into a Database Structure

Appendix E: Comparison of ER Modelling Notations

Appendix F: Client/Server Systems

Appendix G: Object-Orientated Databases

Appendix H: Database in Electronic Commerce

Appendix I: The Hierachical Database Model

Appendix J: The Network Database Model

Appendix K: Database Administration