An Introduction to the Fundamentals of Database Systems

Running head: AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE
SYSTEMS
An Introduction to the Fundamentals of Database Systems
Demystifying Embedded Systems Middleware
Author Name: Tammy Noergaard
Name of the Student
Student ID

1AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE SYSTEMS
1. Introduction
The primary purpose of the report is based on the discussion of the topic based on the
fundamentals of database systems and also discusses about the impacts made by a database
system within any embedded system. The selected article have been chosen based on discussing
about the introduction of the fundamental concepts of database within any computerized system
(Elmasri and Navathe 2016). The article focuses on the various kinds of database models that
would be in relation with the database middleware. The discussion based on the selected article
is based on conducting a study and research on the database systems that help in the underlying
of file systems. The chosen article is based on researching on the various fundamental
applications of database systems in the modern world. The review on this article would also help
in understanding of fundamental concepts that would be helpful in the design of a database
system.
2. Discussion
A database system, which is also known as a Database Management System (DBMS) is
generally referred as a database system that would be used for managing of data within any kind
of embedded computerized system. A centralized database system forms an integral part in the
management of data within an organisation (Coronel and Morris 2016). They are also used
reliably for efficiently managing the data. A database system could be easily accessible by the
user of the embedded system based on the help of other form of middleware software. The
different kind of application used within the system help in the designing of the structure of the
file storage of the organisation. A database is also used for the management of access to the
similar data that would be used within the file system. There is a particular form of design of
database that would not be able to eliminate the redundancy of data (Hababeh, Khalil and
Khreishah 2015). Based on the research on the article under review, it has been seen that the
designs of the DBMS would be mostly implemented within the file system.
Further review on the article helps in understanding that the database system comprises
of two form of major components. These include the overlying middleware or application
software and database. These would be used for the management of access to the centralized
Name of the Student student
id 1

2AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE SYSTEMS
database. The bases help in managing of data based on allowing of the organisation, storing and
managing of interrelated data. They also help in querying of data with the help of a query based
language (Diallo et al. 2015). They also provide the generating of vast amount of reports that
would be based on the analysis of data. Thus, the use of database systems would also underlie
the integrity of data, reduce data redundancy and ensure the security of data. This article has
further put contrast over a variety of data that would be typically be stored within the file system.
This would also simply put the data that would be interrelated (Telnarova and Rombová 2015).
The article discusses that a database system should comprise of an efficient mode of ‘data
modelling’ scheme that would be able to create different components based on storing of data,
processing of data and location of data.
In this article, the research has also been focused on providing examples about the
common form of real-world language that is mainly used within the database systems. The
language used for performing of queries within the database tables is Structured Query Language
(SQL). The SQL is defined as the computer database language, which is mainly used for the
creation, maintaining and co trolling the internal structures of the database (Ong,
Papakonstantinou and Vernoux 2014). The SQL also comprises of DDL, DCL and DML
elements. The article also focuses on a particular form of database system that is known as the
Perst database system, which primarily makes use of procedural query language. This would be
based on deriving the SQL standard that is known as JSQL (Kolonko 2018). The discussion
about the impact of database systems also provide information on the database query languages
that would be either considered as procedural or non-procedural. This article also provides a
detailed analysis of each of the supported languages within the SQL systems.
A thorough observation over the article helps in forming a certain view about the
different kind of operations that are performed within the procedural query language. The
supported examples would help in forming a view about the different situations in which these
queries would be supported (Dalton, Dietz and Allan 2014). These different operations are
mostly used for performing different queries within the database systems. The method of
observation of the functioning of different queries is mainly supported by providing examples of
real-life situation analysis. Based on the performance analysis of the queries, some information is
Name of the Student student
id 2