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
DBMS Introduction
Database Kya Hota Hai?
Database ek aisi jagah hoti hai jahan related data ko store kiya jaata hai — organized tarike se.
Example:
College ka sochiye, jahan yeh sab data store hota hai:
-
Student ka naam
-
Roll number
-
Course
-
Marks
Agar yeh sab data ko proper tarike se store kiya jaye, toh woh Database kehlata hai.
DBMS Kya Hota Hai?
DBMS (Database Management System) ek software hota hai jo database ko store, manage aur retrieve karne mein madad karta hai.
–> Simple bhaasha mein: DBMS = Data store karne ka aur usse manage karne ka ek software system
Real Life Example
Sochiye agar college apne students ka data ek register mein likh kar rakhta ho, toh:
-
Dhoondhna mushkil
-
Update karna tough
-
Galti hone ke chances zyada
Ab sochiye agar yahi data computer par ek software (jaise MySQL ya Oracle) mein store ho:
-
Fast search
-
Easy update
-
Safe data storage
DBMS se fayda hota hai:
-
Naya data add karna
-
Purana data update/delete karna
-
Search karna super fast
Diagram: DBMS Ka Basic Flow
DBMS Ke Main Parts
-
Hardware
– Computer, hard drive, ya server. -
Software
– Jo DBMS chalata hai (e.g., MySQL, Oracle). -
Data
– Actual information (jaise students ka data). -
Users
– Jo system ka use karte hain. -
DBMS Use Karne Wale Log (Users)
User Type | Kya Karte Hain |
---|---|
Database Admin | DB ko manage karta hai |
Programmer | Software banata hai jo DB se judta hai |
End User | Normal users (jaise student ya staff) |
DBMS Ke Fayde (Advantages)
Feature | Fayda |
---|---|
Data Repeat Nahi Hota | Duplicate data se bachaav |
Consistent Data | Sab jagah ek jaise data |
Security | Unauthorized log access nahi kar sakte |
Backup & Recovery | Data khone pe wapas laa sakte hain |
Multiple Users Access | Ek hi data ko kai log use kar sakte hain |
Example: Student Record Table
Roll No | Name | Course | Marks |
---|---|---|---|
101 | Riya | BCA | 85 |
102 | Aman | BBA | 90 |
103 | Sneha | BCA | 88 |
Is table se hum:
-
Sirf BCA wale students nikaal sakte hain
-
Aman ke marks update kar sakte hain
-
Sneha ka record delete bhi kar sakte hain
-
Popular DBMS Softwares
DBMS | Description |
---|---|
MySQL | Free aur easy to use |
Oracle DB | Powerful aur secure (paid) |
MS SQL Server | Microsoft ka DBMS |
MongoDB | NoSQL, unstructured data ke liye |
Summary
Feature | DBMS Summary |
---|---|
Full Form | Database Management System |
Kaam | Data ko store, manage, aur access karna |
Kahan use hota hai | Banks, Colleges, Hospitals, Websites, etc. |
Example | Student Information System |