Course Content
Detailed Content of Database Management System
0/1
About Lesson

Advantages of DBMS:

  1. 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.
  2. Data Sharing: In DBMS, the authorized users of an organization can share the data among multiple users.
  3. 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.
  4. Backup: It provides Backup and Recovery subsystems which create automatic backup of data from hardware and software failures and restores the data if required.
  5. Multiple user interface: It provides different types of user interface like Graphical User Interfaces, Application Program Interfaces.
  6. Privacy/Security: Only authorized users can access database.

Disadvantages of DBMS:

  1. Cost of Hardware and Software: It Requires a high speed of data processor and large memory size to run a DBMS Software.
  2. Size: It Occupies a large space of Disks and Large Memory to run them efficiently.
  3. Complexity: Database system creates additional complexity and requirement.
  4. 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.