Question

DBMS is an example of...​

Answer 1

Answer:

DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro. ... Since there are so many database management systems available, it is important for there to be a way for them to communicate with each other.

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.

• ⟹ Though functions of DBMS vary greatly, general-purpose DBMS features and capabilities should include: a user accessible catalog describing metadata, DBMS library management system, data abstraction and independence, data security, logging and auditing of activity, support for concurrency and transactions, support for authorization of access, access support from remote locations, DBMS data recovery support in the event of damage, and enforcement of constraints to ensure the data follows certain rules.

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

Features of DBMS

• ⟹ Structure: Where data is structured in hierarchical form in a DBMS, data is structured in tabular form in a RDBMS.
• ⟹ User capacity: A RDBMS is capable of operating with multiple users. DBMS can only manage one user at a time.
• ⟹ Software/hardware requirements: A RDBMS has greater software and hardware requirements.
• ⟹ Programs managed: DBMS maintains databases within the computer network and system hard disks. A RDBMS manages the relationships between its incorporated tables of data.
• ⟹ Data capacity: A DBMS is capable of managing small amounts of data and a RDBMS can manage an unlimited amount of data.
• ⟹ Distributed databases: A DBMS does not provide support for distributed databases while a RDBMS does.
• ⟹ ACID implementation: A RDBMS bases the structure of its data on the ACID (Atomicity, Consistency, Isolation, and Durability) model.

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

Function of DBMS

DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are

• ⟹ Data Dictionary Management,
• ⟹ Data Storage Management,
• ⟹ Data Transformation and Presentation,
• ⟹ Security Management,
• ⟹ Multi user Access Control,
• ⟹ Backup and Recovery Management,
• ⟹ Data Integrity Management,
• ⟹ Database Access Languages andApplication Programming Interfaces and
• ⟹ Database Communication interfaces

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

Advantages of DBMS

• ⟹ Data Redundancy
• ⟹ Data Inconsistency
• ⟹ Data Sharing
• ⟹ Data Searching
• ⟹ Data Security
• ⟹ Data Concurrency
• ⟹ Data Integration
• ⟹ Data Access
• ⟹ Decision making
• ⟹ Data Backup and Recovery
• ⟹ Data Migration
• ⟹ Low Maintenance Cost
• ⟹ Data Loss is almost eliminated
• ⟹ Data Atomicity

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

Disadvantage of DBMS

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

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