Skip to main content
  • Book
  • © 2014

Database Systems

A Pragmatic Approach

Apress
  • Database Systems: A Pragmatic Approach provides a comprehensive yet concise introduction to the theory and practice of database systems as they are used in corporate software development.

Buy it now

Buying options

eBook USD 49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (29 chapters)

  1. Front Matter

    Pages i-xxxv
  2. Preliminary Topics

    1. Front Matter

      Pages 1-1
    2. Introduction to Database Systems

      • Elvis C. Foster, Shripad V. Godbole
      Pages 3-11
    3. The Database System Environment

      • Elvis C. Foster, Shripad V. Godbole
      Pages 13-27
  3. The Relational Database Model

    1. Front Matter

      Pages 29-30
    2. The Relational Model

      • Elvis C. Foster, Shripad V. Godbole
      Pages 31-56
    3. Integrity Rules and Normalization

      • Elvis C. Foster, Shripad V. Godbole
      Pages 57-81
    4. Database Modeling and Design

      • Elvis C. Foster, Shripad V. Godbole
      Pages 83-118
    5. Database User Interface Design

      • Elvis C. Foster, Shripad V. Godbole
      Pages 119-127
    6. Relational Algebra

      • Elvis C. Foster, Shripad V. Godbole
      Pages 129-148
    7. Relational Calculus

      • Elvis C. Foster, Shripad V. Godbole
      Pages 149-162
    8. Relational System — a Closer Look

      • Elvis C. Foster, Shripad V. Godbole
      Pages 163-168
  4. The Structured Query Language

    1. Front Matter

      Pages 169-169
    2. Overview of SQL

      • Elvis C. Foster, Shripad V. Godbole
      Pages 171-175
    3. SQL Data Definition Statements

      • Elvis C. Foster, Shripad V. Godbole
      Pages 177-218
    4. SQL Data Manipulation Statements

      • Elvis C. Foster, Shripad V. Godbole
      Pages 219-258
    5. SQL Views and System Security

      • Elvis C. Foster, Shripad V. Godbole
      Pages 259-278
    6. The System Catalog

      • Elvis C. Foster, Shripad V. Godbole
      Pages 279-289
    7. Some Limitations of SQL

      • Elvis C. Foster, Shripad V. Godbole
      Pages 291-297
  5. Some Commonly Used DBMS Suites

    1. Front Matter

      Pages 299-299

About this book

Database Systems: A Pragmatic Approach is a classroom textbook for use by students who are learning about relational databases, and the professors who teach them. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. 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. Upholding his aim for brevity, comprehensive coverage, and relevance, author Elvis C. Foster's practical and methodical discussion style gets straight to the salient issues, and avoids unnecessary fluff as well as an overkill of theoretical calculations.

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 Foster's original methodologies that add clarity and creativity to the database modeling and design experience while making a novel contribution to the discipline. Everything combines to make Database Systems: A Pragmatic Approach an excellent textbook for students, and an excellent resource on theory for the practitioner.

About the authors

Elvis C. Foster is Associate Professor of Computer Science at Keene State College, New Hampshire. He holds a Bachelor of Science (BS.) in Computer Science and Electronics, as well as a Doctor of Philosophy (PhD) in Computer Science (specializing in strategic information systems and database systems) from University of the West Indies, Mona Jamaica. Dr. Foster has over 22 years of combined experience as a software engineer, information technology executive and consultant, and computer science educator.

Bibliographic Information

Buy it now

Buying options

eBook USD 49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access