Database Essentials – Table of Contents

  1. Preliminaries
    1.1 Introduction
  2. Information Modeling
    2.1 Introduction
    2.2 What to Model
    2.3 How to Model
    2.4 ODM: An Object Data Model
  3. The Relational Data Model
    3.1 Introduction
    3.2 Relational algebra
    3.3 Relational Database Design: ODM-to-Relational Mapping
    3.4 Relational Database Design: Normalization Theory
  4. Objective of a DBMS
    4.1 Introduction
    4.2 Functions of a DBMS
  5. SQL: A Relational Database Language
    5.1 Introduction
    5.2 The Data Definition Sublanguage
    5.3 Access Control
    5.4 The Query Sublanguage
    5.5 Aggregation over Data
    5.6 Nested Queries
    5.7 Queries that Require Universal Quantifiers
    5.8 Modifying Relation Instances
    5.9 Executing SQL Commands within Application Programs
    5.10 Exercises
  6. DBMS Architecture
    6.1 Introduction
    6.2 Storing Collections of Records
    6.3 Heap and Sequential Organizations
    6.4 Primary Key Organizations
    6.5 Solutions for Relational DBMS
    6.6 Query Processing
    6.7 Concurrency and Recovery
    6.8 Exercises
  7. Final Remarks
  8. Bibliography