About Lesson
Advantages of DBMS:
- Controls Database Redundancy: It can Control data redundancy because it Stores all the data in one Single database file and that recorded data is placed in the Database.
- Data Sharing: In DBMS, the authorized users of an organization can share the data among multiple users.
- Concurrency Control: A DBMS provides a strong Concurrency Control System, because of the transaction are neither lost nor performed incorrectly, when two or more users use it at the same time simultaneously.
- Backup: It provides Backup and Recovery subsystems which create automatic backup of data from hardware and software failures and restores the data if required.
- Multiple user interface: It provides different types of user interface like Graphical User Interfaces, Application Program Interfaces.
- Privacy/Security: Only authorized users can access database.
Disadvantages of DBMS:
- Cost of Hardware and Software: It Requires a high speed of data processor and large memory size to run a DBMS Software.
- Size: It Occupies a large space of Disks and Large Memory to run them efficiently.
- Complexity: Database system creates additional complexity and requirement.
- High cost of DBMS: This is one of the major disadvantages of DBMS. A complete DBMS is very large and sophisticated software and is expensive to purchase.