Question

Explain dbms and its characteristics? also discuss its applications and functions.

Answer 1

DBMS is also referred as Data base management system that is used by organizations to help secure and manage their valuable database. Some important features may include:-

• It prevents redundancy and duplication as the files are shared only once reducing chances of duplicity.

• Reduces cost and space of storage using best integration of data.

• It does not require developing special skills to use it as it offers with easy to understand language. Thus process of search, update or delete data is simplified.

• Best maintenance against big volume of data thus preventing your data loss.

• It offers with quality back up and recovery features for your lost or secured data.

• Offers with better security for your data for organizations at the time of handling data. It offers with limited data access.

• It also offers with permanent solutions for data storage for users.

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.

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

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.

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

Function of DBMS

• ⟹ Data Dictionary Management,
• ⟹ Data Storage Management,
• ⟹ Data Transformation and Presentation,
• ⟹ Security Management,
• ⟹ Multi user Access Control,
• ⟹ Backup and Recovery Management,

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