What Are The Disadvantages And Advantages Of Database Management System?


5 Answers

Anonymous Profile
Anonymous answered
• Data is located near the greatest demand site.
• Access to data is faster; processing is faster due to several sites spreading out the work load.
• New sites can be added quickly and easily
• Communication is improved
• Operating costs are reduced
• It is user friendly
• There is less danger of a single-point failure
• It has process independence
• Data can physically reside nearest to where it is most often accessed, thus providing users with local control of data that they interact with. This results in local autonomy of the data allowing users to enforce locally the policies regarding access to their data.
• Reduced data redundancy
• Reduced updating errors and increased consistency
• Greater data integrity and independence from applications programs
• Improved data access to users through use of host and query languages
• Improved data security
• Reduced data entry, storage, and retrieval costs
• Facilitated development of new applications program

• Database systems are complex, difficult, and time-consuming to design
• Substantial hardware and software start-up costs
• Damage to database affects virtually all applications programs
• Extensive conversion costs in moving form a file-based system to a database system
• Initial training required for all programmers and users
• Unemployment will increase as less labor will be required
• Investment needed as computer system and software need to be purchased.
• Computer literate employees needed because only computer literate can use it.
Anonymous Profile
Anonymous answered
Some disadvantages of d.b.m.s.
1)confidentiality,privacy and security-  
2)data inegrity
3)data quality.
4)the cost of a dbms
5)enterprise vulnerbility
Anonymous Profile
Anonymous answered
DBMS can have several advantages - I name just a few

Sharing of information
Real time transactional processing
Historical track record for auditing and control
A good disaster recovery plan may save a business from bankruptcy

Here are some disadvantages

DBMS subjects a business to a risk in the loss of critical data in its electronic format it can be more readily stolen without proper security

The cost of a DBMS can be prohibitive for small enterprises as they struggle with cost justification for making the investment in the infrastructure

Improper use of the DBMS can lead to incorrect decision making as people take for granted the data is accurate as presented.
venus gray Profile
venus gray answered
He advantages of DBMS are as follows:
-Controlling redundancy

-Providing storage structure for efficient query processing.

-Restricting unauthorized users.
-Providing concurrency.

-Providing backup and recovery.
-Enforcing integrity constraints.

The disadvantages are as follows:
-Centralization:That is use of
the same program at a time by many user sometimes lead to loss of some
-High cost of software.

Technical expertise are required

power dependency

security issues
Anonymous Profile
Anonymous answered
Advantages &
  of database systems
  Database advantages include
  the following:
  Shared data;centralized control; disadvantages of redundancy
  control; improved data integrity;improved data security,
  and database systems; and, flexible conceptual design. 
  of database system
  Disadvantages are as follows:
  A complex conceptual design
  process;the need for multiple external
  databases;the need to hire database-related
  employees;high DBMS acquisition costs;a more complex programmer
  environment;potentially catastrophic
  program failures;a longer running time for
  individual applications; and,highly dependent DBMS operations. From  a  source in  the  google

Answer Question