MySQL + SQL · Lesson 8
Advantages and Limitations of DBMS
Advantages of DBMS
| Advantage | Meaning |
|---|---|
| Reduced redundancy | Data stored once, linked by keys |
| Consistency | One update reflects everywhere |
| Data sharing | Many users at once |
| Security | User-level permissions |
| Integrity | Constraints keep data valid |
| Backup & recovery | Automatic 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.
💻 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ें.