Articles
- Database Concepts and Architecture
- Introduction to DBMS
- Database Users and Administrator
- Data Models, Schemas, and Instances
- Three-Schema Architecture and Data Independence
- Database Languages and Interfaces
- The Database System Environment
- Centralized and Client/Server Architectures for DBMSs
- Classification of Database Management Systems
- Data Modelling Using Entity-Relational Model and Relational Model
- The Relational Algebra and Relational Calculus
- Database Normalization
- SQL
- Transaction Processing, Concurrency Control and Recovery Techniques
- Introduction to Transaction Processing
- Serializability
- Introduction to Concurrency Control
- Concurrency Control Techniques
- Introduction to Database Recovery
- Recovery Based on Deferred Update
- Recovery Technique Based on Immediate Update
- Shadow Paging
- Database Backup and Recovery from Catastrophic Failures
- Advanced Topics
- Model Question Solution – DBMS