This course explores the design and implementation of database systems, covering fundamental data models and query languages such as SQL and stored procedures. Students will examine transaction processing (ACID and concurrency control) and recovery mechanisms, including logging and checkpoints. A core component of the curriculum is a hands-on project involving three-tier database architecture. This course is designed for students with a strong programming background.

Outline of Lectures

1. Basic Database Concepts and Architecture
2. Entity Relationship (E-R)Model and Enhanced Entity Relationship (EER) Model
3. Relational Data Model, Query Algebra
4. Structured Query Language (SQL)
5. Database Design
6. Transaction Management
7. Concurrency Control and Recovery
8. Data warehousing
9. Practical Database in Enterprise