Importance of Database Management Systems (DBMSs) in Real-World Scenarios

DATABASE 1
Database
Student Name
Institutional Affiliation

DATABASE 2
Table of Contents
Introduction......................................................................................................................................3
Importance of DBMSs.....................................................................................................................3
DBMS Experience...........................................................................................................................3
Real-World Scenarios......................................................................................................................4
Conclusion.......................................................................................................................................4
Reference List..................................................................................................................................5
Appendix: ER Diagrams..................................................................................................................6

DATABASE 3
Introduction
A database management system (DBMS) is a program software that is used to manage and
process data more easily, efficiently, and in a more reliable way (Yadav and Kumari, 2016).
DBMS or RDBMS are very important today because they are needed to process queries issued
by users and manage objects.
Importance of DBMSs
DBMS are used in retrieving information from the database, updating, and managing the
database. DBMS provides users with numerous functionalities that cannot be met by the
traditional file system. Secondly, database management systems are used to control
inconsistencies and redundancies in the database. In order to avoid duplicates and redundancies,
DBMS uses data normalization. Thirdly, these systems are used to efficiently manage memory
and indexing. That is, it makes management of complex memory partitions easier to handle.
DBMS employs the use of database schema to efficiently undertake object indexing depending
on any attribute of data-property or data. This is very helpful in retrieving data faster depending
on the attribute that is indexed. Fourthly, DBMS are very essential in managing transactions and
concurrency control. This facilitates management of several users accessing the database
simultaneously. Moreover, it helps implement database access control or ease of access, integrity
constraints, and management (Harshika, 2019). Other factors that makes it necessary to have a
DBMS include data expansibility, scalability, and flexibility, security, and multiple user
interfaces.
DBMS Experience
I have interacted with several such as Microsoft SQL having been introduced in 2017 and have
worked with since then. I have operated in both SQL server 2016 and 2014 including MongoDB.
Additionally, experience with on-premise databases. I have a developed a culture to keep up with
the latest trends in database administration and management and get relevant and broad
knowledge on the same. I have also gained knowledge in identifying various issues and problems
affecting the database and determining the cause that may cause the problems affecting the