Question

What is DBMS? Explain advantages and limitation of DBMS.​

Answer 1

Answer:

Database Management System (DBMS) is a software for storing and retrieving users' data while considering appropriate security measures.The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data.

Advantages of DBMS

• DBMS offers a variety of techniques to store & retrieve data
• DBMS serves as an efficient handler to balance the needs of multiple applications using the same data
• Uniform administration procedures for data
• Application programmers never exposed to details of data representation and storage.

limitations of DBMS

• More Costly. Creating and managing a database is quite costly. ...
• High Complexity. A Database Management System is quite complex as it involves creating, modifying and editing a database. ...
• Database handling staff required. ...
• Database Failure. ...
• High Hardware Cost. ...
• Huge Size. ...
• Upgradation Costs. ...

• Cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.
• Most database management systems are often complex systems, so the training for users to use the DBMS is required.
• In some organizations, all data is integrated into a single database which can be damaged because of electric failure or database is corrupted on the storage media.

Answer 2

$\green{ \fcolorbox{grey}{grey}{ \checkmark \: \textsf{Verified \: answer}}}$

What is DBMS

• ⟹ DBMS software primarily functions as an interface between the end user and the database, simultaneously managing the data, the database engine, and the database schema in order to facilitate the organization and manipulation of data.

Advantages of DBMS

• ⟹ Data Redundancy
• ⟹ Data Inconsistency
• ⟹ Data Sharing
• ⟹ Data Searching
• ⟹ Data Security
• ⟹ Data Concurrency
• ⟹ Data Integration
• ⟹ Data Access

━━━━━━━━━━━━━━━━━━━━━━

Disadvantage of DBMS

• ⟹ High Cost.
• ⟹ Size.
• ⟹ Database Failure.
• ⟹ Database Failure
• ⟹ Increased Staff Cost.
• ⟹ Requirement of Technical Staff.

━━━━━━━━━━━━━━━━━━━━━━