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.

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

WhatsApp