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
  8. DBMS interview questions | Set 1
  9. DBMS interview questions | Set 2

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
  7. Quiz on ER and Relational Model

Relational Algebra :

  1. Introduction
  2. Basic Operators
  3. Extended Operators
  4. Inner Join vs Outer Join
  5. How to solve Relational Algebra Problems for GATE
  6. 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

Normalization :

  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. Quiz on Normal Forms
  8. Denormalization in Databases
  9. DBMS | Data Replication
  10. Quiz on Normal Forms

Transactions and Concurrency Control :

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

Indexing, B and B+ trees :

  1. Indexing and its Types
  2. B-Tree | Set 1 (Introduction)
  3. B-Tree | Set 2 (Insert)
  4. B-Tree | Set 3 (Delete)
  5. B+ Tree (Introduction)
  6. Quizzes on Indexing, B and B+ Trees
  7. Bitmap Indexing
  8. Practice questions on B and B+ Trees

File Organization :

  1. File Organization – Set 1
  2. File Organization – Set 2 (Hashing in DBMS)
  3. File Organization – Set 3
  4. Quiz on File structures

Advanced Topics :

  1. RAID
  2. Query Optimization
  3. How to store a password in database?
  4. Data Warehousing
  5. Data Mining

SQL :

  1. SQL | Tutorials
  2. Quiz on SQL

DBMS practices questions :

  1. Database Management Systems | Set 1
  2. Database Management Systems | Set 2
  3. Database Management Systems | Set 3
  4. Database Management Systems | Set 4
  5. Database Management Systems | Set 5
  6. Database Management Systems | Set 6
  7. Database Management Systems | Set 7
  8. Database Management Systems | Set 8
  9. Database Management Systems | Set 9
  10. Database Management Systems | Set 10
  11. Database Management Systems | Set 11

Quick Links :

  1. Last Minutes Notes on DBMS
  2. ‘Practice Problems’ on DBMS !
  3. ‘Quizzes’ on DBMS !
  4. Ask a Question on ‘DBMS’

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.




Company Wise Coding Practice    Topic Wise Coding Practice