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.

    5.  

     DBMS Use Karne Wale Log (Users)

    User TypeKya Karte Hain
    Database AdminDB ko manage karta hai
    ProgrammerSoftware banata hai jo DB se judta hai
    End UserNormal users (jaise student ya staff)

     

     DBMS Ke Fayde (Advantages)

    FeatureFayda
    Data Repeat Nahi HotaDuplicate data se bachaav
    Consistent DataSab jagah ek jaise data
    SecurityUnauthorized log access nahi kar sakte
    Backup & RecoveryData khone pe wapas laa sakte hain
    Multiple Users AccessEk hi data ko kai log use kar sakte hain

     Example: Student Record Table

    Roll NoNameCourseMarks
    101RiyaBCA85
    102AmanBBA90
    103SnehaBCA88

        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

    DBMSDescription
    MySQLFree aur easy to use
    Oracle DBPowerful aur secure (paid)
    MS SQL ServerMicrosoft ka DBMS
    MongoDBNoSQL, unstructured data ke liye

     Summary 

    FeatureDBMS Summary
    Full FormDatabase Management System
    KaamData ko store, manage, aur access karna
    Kahan use hota haiBanks, Colleges, Hospitals, Websites, etc.
    ExampleStudent Information System
    Scroll to Top