Advertisement

Database Systems

A Pragmatic Approach

  • Elvis C. Foster
  • Shripad Godbole

Table of contents

  1. Front Matter
    Pages i-xxxviii
  2. Preliminary Topics

    1. Front Matter
      Pages 1-1
    2. Elvis C. Foster, Shripad Godbole
      Pages 3-14
    3. Elvis C. Foster, Shripad Godbole
      Pages 15-33
  3. The Relational Database Model

    1. Front Matter
      Pages 35-35
    2. Elvis C. Foster, Shripad Godbole
      Pages 37-72
    3. Elvis C. Foster, Shripad Godbole
      Pages 73-100
    4. Elvis C. Foster, Shripad Godbole
      Pages 101-137
    5. Elvis C. Foster, Shripad Godbole
      Pages 139-153
    6. Elvis C. Foster, Shripad Godbole
      Pages 155-179
    7. Elvis C. Foster, Shripad Godbole
      Pages 181-194
    8. Elvis C. Foster, Shripad Godbole
      Pages 195-201
  4. The Structured Query Language

    1. Front Matter
      Pages 203-203
    2. Elvis C. Foster, Shripad Godbole
      Pages 205-209
    3. Elvis C. Foster, Shripad Godbole
      Pages 211-248
    4. Elvis C. Foster, Shripad Godbole
      Pages 249-303
    5. Elvis C. Foster, Shripad Godbole
      Pages 305-325
    6. Elvis C. Foster, Shripad Godbole
      Pages 327-338
    7. Elvis C. Foster, Shripad Godbole
      Pages 339-345
  5. Advanced Topics

    1. Front Matter
      Pages 347-347
    2. Elvis C. Foster, Shripad Godbole
      Pages 349-359
    3. Elvis C. Foster, Shripad Godbole
      Pages 361-370
    4. Elvis C. Foster, Shripad Godbole
      Pages 371-376
    5. Elvis C. Foster, Shripad Godbole
      Pages 377-390
    6. Elvis C. Foster, Shripad Godbole
      Pages 391-401
    7. Elvis C. Foster, Shripad Godbole
      Pages 403-432
  6. Overview of Selected DBMS Suites

    1. Front Matter
      Pages 433-433
    2. Elvis C. Foster, Shripad Godbole
      Pages 435-442
    3. Elvis C. Foster, Shripad Godbole
      Pages 443-450
    4. Elvis C. Foster, Shripad Godbole
      Pages 451-460
    5. Elvis C. Foster, Shripad Godbole
      Pages 461-467
  7. Appendices

    1. Front Matter
      Pages 469-469
    2. Elvis C. Foster, Shripad Godbole
      Pages 471-504
    3. Elvis C. Foster, Shripad Godbole
      Pages 505-522
    4. Elvis C. Foster, Shripad Godbole
      Pages 523-538
    5. Elvis C. Foster, Shripad Godbole
      Pages 539-583
    6. Elvis C. Foster, Shripad Godbole
      Pages 585-595
  8. Back Matter
    Pages 597-604

About this book

Introduction

This book provides a comprehensive, yet concise introduction to database systems, with special emphasis on the relational database model. The book discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. New in this second edition is updated SQL content covering the latest release of the Oracle Database Management System along with a reorganized sequence of the topics which is more useful for teaching. Also included are revised and additional illustrations, as well as a new chapter on using relational databases to anchor large, complex management support systems. There is also added reference content in the appendixes.

The book is based on lecture notes that have been tested and proven over several years, with outstanding results. It also exemplifies mastery of the technique of combining and balancing theory with practice, to give students their best chance at success.

The book discusses concepts, principles, design, implementation, and management issues of databases. Each chapter is organized systematically into brief, reader-friendly sections, with itemization of the important points to be remembered. It adopts a methodical and pragmatic approach to solving database systems problems. Diagrams and illustrations also sum up the salient points to enhance learning. Additionally, the book includes a number of Elvis Foster's original methodologies that add clarity and creativity to the database modeling and design experience, while making a novel contribution to the discipline. These features combine to make Database Systems: A Pragmatic Approach an excellent textbook for students and reader-friendly resource on database theory for the practitioner.



Keywords

Relational Model Normalization Integrity Rules Relational Algebra Relational Calculus SQL Data Definition Language DDL Data Manipulation Language DML Object Databases

Authors and affiliations

  • Elvis C. Foster
    • 1
  • Shripad Godbole
    • 2
  1. 1.Associate Professor of Computer ScienceKeene State CollegeNew HampshireUSA
  2. 2.Senior Manager of Database AdministrationMerkle Inc.MarlboroughUSA

Bibliographic information