Database Systems: An Application Oriented Approach – Michael Kifer, Arthur Bernstein, Philip M. Lewis – 2nd Edition

PART ONE Introduction
1 Overview of Databases and Transactions
2 The Big Picture

PART TWO Database Management
3 The Relational Data Model
4 Conceptual Modeling of Databases with Entity-Relationship
Diagrams and the Unified Modeling Language
5 Relational Algebra and SQL
6 Database Design with the Relational Normalization Theory
7 Triggers and Active Databases
8 Using SQL in an Application

PART THREE Optimizing DBMS Performance
9 Physical Data Organization and Indexing
10 The Basics of Query Processing
11 An Overview of Query Optimization
12 Database Tuning

PART FOUR Advanced Topics in Databases
13 Relational Calculus, Visual Query Languages, and Deductive Databases
14 Object Databases
15 XML and Web Data
16 Distributed Databases
17 OLAP and Data Mining

PART FIVE Transaction Processing
18 ACID Properties of Transactions
19 Models of Transactions
20 Implementing Isolation
21 Isolation in Relational Databases
22 Atomicity and Durability

PART SIX Distributed Applications and the Web
23 Architecture of Transaction Processing Systems
24 Implementing Distributed Transactions
25 Web Services
26 Security and Electronic Commerce
A An Overview of Transaction Processing
Exercises
B Requirements and Specifications
C Design, Coding, and Testing