Database Management Systems: Discussion on Importance and Applications

This discussion board post explores the significance of Database Management Systems (DBMS) and Relational Database Management Systems (RDBMS), highlighting their necessity in managing and processing data efficiently. The author shares their experience with DBMS tools like Microsoft SQL, including versions 2014 and 2016, and MongoDB, emphasizing continuous learning and problem-solving skills in database administration. Real-world examples from Barclays Bank, Amazon, and Alibaba illustrate how DBMS are crucial for managing transactions and vast amounts of data. The discussion concludes by emphasizing the strategic benefits of DBMS, such as improved data analysis, reduced redundancy, enhanced security, and increased accessibility. The post also includes Entity-Relationship (ER) diagrams for Colonial Adventure Tours, BITS, and Sports Physical Therapy databases.

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

DATABASE 4
database such as data loss. This include identifying if the problem is recurrent or one-time. Some
of the technical knowledge that I have gained over time include database backup and restoration,
optimizing and implementing Hadoop solutions and maintaining database servers.
Real-World Scenarios
Many companies and organizations are making use of database management systems. Such
organizations include Barclays Bank (including other banks) and Alibaba, Amazon amongst
other financial and e-commerce institutions. Such institutions utilize database management
systems to manage the various transaction (for Barclays Bank and other banking institutions)
such as cash deposits, withdrawals, and transfers to ensure that the correct figure/amount is
deducted or added, and it should be (no data redundancy or unsuccessful transactions).
Ecommerce companies such as Amazon and Alibaba are using DBMS software to manage many
orders made by customers across the globe. The companies cited deals with numerous and vast
amount of data which cannot be handled or managed manually and thus the need to have a
database management system (Thiru, 2019).
Conclusion
DBMS also improves strategic use of the data collected through analysis to identify new
opportunities and trends, reduces complexity, data redundancy and inconsistency, improves data
integrity, enhances data security, reduced maintenance and application development costs,
increases data availability and accessibility, and facilitates application-data independence.

DATABASE 5
Reference List
Harshika, V. (2019). Need for DBMS - GeeksforGeeks. [online] GeeksforGeeks. Available at:
https://www.geeksforgeeks.org/need-for-dbms/ [Accessed 13 Jan. 2019].
Thiru, N. (2019). Role of Databases in An Organizations. [online] Myreadingroom.co.in.
Available at: http://www.myreadingroom.co.in/notes-and-studymaterial/65-dbms/569-role-of-
databases-in-an-organizations.html [Accessed 13 Jan. 2019].
Yadav, M. and Kumari, S. (2016). A Paradigm for Active Database Management
Systems. International Journal Of Engineering And Computer Science.

DATABASE 6
Appendix: ER Diagrams
Figure 1: Colonial Adventure Tours ER Diagram
Figure 2: BITS ER Diagram

DATABASE 7
Figure 3: Sports Physical Therapy ER Diagram