TheHingineer

  • DBMS


  • DBMS Part-1

  • DBMS Part-2

  • DBMS Part-3

  • DBMS Part-4

  • 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 Introduction

     DBMS Ke Main Parts

    1. Hardware
      – Computer, hard drive, ya server.

    2. Software
      – Jo DBMS chalata hai (e.g., MySQL, Oracle).

    3. Data
      – Actual information (jaise students ka data).

    4. 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
    Scroll to Top