Part I: Database Concepts

1. Database Systems
2. Data Models

Part II: Design Concepts

3. The Relational Database Model
4. Entity Relationship (ER) Modeling
5. Normalization of Database Tables
6. Advanced Data Modeling

Part III: Advanced Design and Implementation

7. Introduction to Structured Query language (SQL)
8. Advanced SQL
9. Database Design

Part IV: Advanced Database Concepts

10. Transaction Management and Concurrency Control
11. Database Performance Tuning and Query Optimization
12. Distributed Database Management Systems
13. The Data Warehouse

Part V: Databases and the Internet

14. Database Connectivity and Web Development

Part VI: Database Administration

15. Database Administration

Appendices (online)

A. Designing Databases with Visio Professional: A Tutorial
B. The University Lab: Conceptual Design
C. The University Lab: Conceptual Design Verification, Logical Design, and Implementation
D. Converting ER Model into a Database Structure
E. Comparison of ER Model Notations
F. Client/Server Systems
G. Object Oriented Databases
H. Unified Modeling Language (UML)
I. Databases in Electronic Commerce
J. Web Database Development with ColdFusion
K. The Hierarchical Database Model
L. The Network Database ModelA
Answers to Selected Questions and Problems