Database Management System (DBMS)

‘Recent Articles’ on DBMS !

Introduction :

  1. DBMS Introduction | Set 1
  2. DBMS Introduction | Set 2 (3-Tier Architecture)
  3. DBMS Architecture 2-level 3-level
  4. Need For DBMS
  5. Data Abstraction and Data Independence
  6. Database Objects
  7. Multimedia Database

Entity Relationship Model :

  1. ER Model
  2. Enhanced ER Model
  3. Minimization of ER Diagram
  4. ER Model: Generalization, Specialization and Aggregation
  5. Recursive Relationships

Relational Model :

  1. Relational Model and CODD Rules
  2. Relational Model
  3. Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
  4. Number of possible Superkeys
  5. Anomalies in Relational Model
  6. Mapping from ER Model to Relational Model

>> Quiz on ER and Relational Model

Relational Algebra :



  1. Introduction
  2. Basic Operators
  3. Extended Operators
  4. Inner Join vs Outer Join
  5. DBMS | Tupple Relational Calculus
  6. How to solve Relational Algebra Problems for GATE
  7. How to Solve Relational Algebra Problems for GATE

Functional Dependencies :

  1. Functional Dependency and Attribute Closure
  2. Finding Attribute Closure and Candidate Keys using Functional Dependencies
  3. Armstrong’s Axioms in Functional Dependency
  4. Equivalence of Functional Dependencies
  5. Canonical Cover

Normalisation :

  1. Introduction
  2. Normal Forms
  3. Dependency Preserving Decomposition
  4. Lossless Join Decomposition
  5. LossLess Join and Dependency Preserving Decomposition
  6. How to find the Highest Normal Form of a Relation
  7. Denormalization in Databases
  8. DBMS | Data Replication

>> Quiz on Normal Forms

Transactions and Concurrency Control :

  1. Introduction
  2. ACID Properties
  3. Concurrency Control -Introduction
  4. Implementation of Locking in DBMS
  5. Concurrency Control Protocols – Lock Based Protocol
  6. Concurrency Control Protocol | Graph Based Protocol
  7. Concurrency Control Protocol | Two Phase Locking (2-PL)-I
  8. Concurrency Control Protocol | Two Phase Locking (2-PL)-II
  9. Concurrency Control Protocol | Two Phase Locking (2-PL)-III
  10. Concurrency Control Protocol | Multiple Granularity Locking
  11. Concurrency Control Protocol | Thomas Write Rule
  12. DBMS | Log based recovery
  13. Timestamp Ordering Protocols
  14. Introduction to TimeStamp and Deadlock Prevention Schemes
  15. Types of Schedules
  16. Conflict Serializability
  17. View Serializability
  18. How to test if two schedules are View Equal or not ?
  19. Recoverability of Schedules
  20. Precedence Graph for testing Conflict Serializabilty
  21. Transaction Isolation Levels in DBMS
  22. Database Recovery Techniques
  23. Starvation in DBMS
  24. Deadlock in DBMS
  25. DBMS | OLAP vs OLTP
  26. DBMS | Types of Recoverability of Schedules and easiest way to test schedule | Set 2

>> Quiz on Transactions and concurrency control

Indexing, B and B+ trees :