List the advantages and disadvantages of DBMS over conventional file system?

Answer 1

DBMS can have several advantages - I am just giving a few of them...

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

Here are some disadvantages

1. 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

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

3. Improper use of the DBMS can lead to incorrect decision making as people take for granted the data is accurate as presented.

4. Datas can be stolen by careless of the password security.

Answer 2

Advantages

• Reduced data redundancy (Data security)
• 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
• Frequent use
• Easy Data control
• Accuracy
• Better processing speed
• Reuse of data code
• Remote access
• Efficiency
• Easy to find related information

Disadvantages

• 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

Answer 3

program data dependency