MySQL + SQL · Lesson 8

Advantages and Limitations of DBMS

Advantages of DBMS

AdvantageMeaning
Reduced redundancyData stored once, linked by keys
ConsistencyOne update reflects everywhere
Data sharingMany users at once
SecurityUser-level permissions
IntegrityConstraints keep data valid
Backup & recoveryAutomatic protection

Limitations of DBMS

  • Cost: Software, hardware and trained staff are expensive.
  • Complexity: Designing and managing needs skill.
  • Size: DBMS software itself takes large memory/disk.
  • Risk: If the central database fails, everything stops (single point).

Summary

  • Advantages: less redundancy, consistency, sharing, security, integrity, recovery.
  • Limitations: cost, complexity, size and central failure risk.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

\n

💻 Live Code Editor

Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.
Powered by OneCompiler. Agar editor na khule to yahान naye tab mein kholein.

💻 Live Code Editor

Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.
Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें. Agar load na ho to naye tab mein kholें.