Skip to main content

Advantages and Limitations

A good database management system (DBMS) should provide the following advantages over a conventional system:

Advantages

  1. Reduced data redundancy
  2. Reduced updating errors and increased consistency
  3. Greater data integrity and independence from applications programs
  4. Improved data access to users through use of host and query languages
  5. Improved data security
  6. Reduced data entry, storage, and retrieval costs

However, the following can be viewed as some of the limitations of a database:

Disadvantages

  1. Database systems are complex, difficult, and time-consuming to design
  2. Substantial hardware and software start-up costs
  3. Damage to database affects virtually all applications programs
  4. Extensive conversion costs in moving form a file-based system to a database system
  5. Initial training required for all programmers and users

You can find out more about: Advantages and Limitations of Databases

Next: Stages in Creating a Database