DBMS
DBMS Part-1
- DBMS Introduction
- DBMS Architecture
- Database Approach vs Traditional File System
- Advantages of DBMS
- Data Models in DBMS
- Schemas in DBMS
- Instances in DBMS
- Data Independence in DBMS
- Database Languages in DBMS
- Interfaces in DBMS
- Structure of DBMS
- Functions of DBA and Designer
- Entities and Attributes in DBMS
- ER Diagram in DBMS
- Generalization, Specialization and Aggregation in DBMS
- Converting ER Diagram to Tables in DBMS
- Difference between Object Oriented, Network and Relational Data Models
DBMS Part-2
- Relational Data Model in DBMS
- Keys in DBMS
- SQL Introduction
- DDL(Data Definition Language)
- DML(Data Manipulation Language)
- Integrity Constraints in DBMS
- Complex SQL Queries
- Joins in DBMS
- Indexing in DBMS
- Triggers in DBMS
- Assertions in DBMS
- Relational Algebra in DBMS
- Tuple Relational Calculus in DBMS
- Domain Relational Calculus in DBMS
DBMS Part-3
- Introduction to Normalization in DBMS
- Normal Forms in DBMS
- Functional Dependency in DBMS
- Decomposition in DBMS
- Dependency Preserving Decomposition in DBMS
- Lossless Join Decomposition in DBMS
- Problems with Null Values and Dangling Tuples
- Multivalued Dependency in DBMS
- Query Optimization in DBMS
- Algorithms for Select, Project and Join Operations in DBMS
- Query Optimization Methods in DBMS
DBMS Part-4
- Transactions in DBMS
- Serializability in DBMS
- Recoverability in DBMS
- Recovery Techniques in DBMS
- Log Based Recovery in DBMS
- Checkpoint in DBMS
- Deadlock in DBMS
- Concurrency Control in DBMS
- Lock Based Protocol in DBMS
- Timestamp Based Protocol in DBMS
- Validation Based Protocol in DBMS
- Multiple Granularity in DBMS
- Multi-Version Concurrency Control(MVCC) in DBMS
- Recovery with Concurrent Transactions in DBMS
DBMS Part-5
Database Approach vs Traditional File System – Simple Hinglish Mein
Traditional File System Kya Hai?
Traditional file system mein, har application ya department apna data alag file mein rakhta hai. Files ko manually handle kiya jaata hai, aur koi centralized system nahi hota.
Example:
Sochiye ek college mein:
Students ka data →
students.txt
Exams ka data →
exams.txt
Fees ka data →
fees.txt
Yeh alag-alag files hoti hain, jinko departments khud handle karte hain. Data share karna mushkil hota hai, aur galti hone ke chances zyada hote hain.
Database Approach Kya Hai?
Database approach mein, poora data ek hi centralized system (DBMS) ke through manage hota hai. Har department ya application usi centralized database se data access karta hai.
Example:
Ab wahi college ek database use karta hai:
Sabhi data (students, exams, fees) ek single database mein stored hota hai
Sabhi departments usi data ko use karte hain
Har user ko updated aur consistent data milta hai
Diagram: Traditional vs Database Approach
Traditional File System:
Student App → students.txt
Exam App → exams.txt
Fees App → fees.txt
(No central system)
Database System (DBMS):
Student App
|
Exam App → DBMS →Central Database
|
Fees App
(DBMS controls data access)
Traditional File System vs Database Approach: Comparison
Feature | Traditional File System | Database System (DBMS) |
---|---|---|
Data Repeat | Zyada repeat hota hai | Kam repeat hota hai |
Inconsistency | Ek jaisa data sab jagah nahi hota | Data same hota hai sab jagah |
Security | Low – har file open kar sakte ho | High – DBMS se control hota hai |
Multi-User Support | Difficult – coordination nahi hoti | Easy – multiple log ek sath access karte |
Data Sharing | Mushkil hota hai | Easy – centralized sharing |
Maintenance | Hard – sab file alag handle karni padti | Easy – ek jagah change karo sab jagah effect |
Backup/Recovery | Manual karna padta hai | DBMS automatically manage karta hai |
Simple Example
Traditional File System:
Student ka naam teen files mein stored hai:
students.txt
exams.txt
fees.txt
Agar naam change karo sirf ek file mein, baaki mein nahi — data mismatch ho sakta hai.
Database Approach:
Student ka naam sirf ek table mein store hota hai, aur sabhi modules wahi data use karte hain.
Naam ek jagah update karo → sab jagah change ho jaata hai.
Database Approach ke Fayde (Advantages)
-> Repeated data kam hota hai
-> Security zyada hoti hai
-> Multiple users access kar sakte hain
-> Consistent data sabko milta hai
-> Backup aur recovery easy hoti hai
Traditional File System ke Nuksan
-> Data duplication hota hai
-> Data mismatch ho sakta hai
-> Security weak hoti hai
-> Multi-user support nahi hota
-> Data share karna mushkil hota hai
Short Summary Table
Feature | Traditional File System | Database System (DBMS) |
---|---|---|
Data Redundancy | High | Low |
Inconsistency Risk | High | Low |
Security | Low | High |
Data Sharing | Difficult | Easy |
Access by Many Users | Mushkil | Easy |
Maintenance | Hard | Easy |