Database Management System Analysis

Running head: DATABASE SYSTEM
DATABASE SYSTEM
Name of the Student
Name of the University
Author Note

DATABASE SYSTEM1
Table of Contents
Database design and its implementation based on the given scenario:......................................2
1. Justifications:...................................................................................................................4
2. The detailed process of implementing the database using SQL:....................................4
Poster on Kaggle Dataset Analysis:.........................................................................................13
References:...............................................................................................................................14

DATABASE SYSTEM2
Database design and its implementation based on the given scenario:
After analyzing the case study, it can conclude that in this scenario SQL database is
appropriate because it stores data in for of table. And the mission details, agency details,
country, mission date, equipment, quantity, item weight and the total weight details can be
store in the form of table efficiently. Basically, database designing is the way of organizing
the data into the database model. a database designer should know what the appropriate data
type how to implement it in the database. After analyzing the data and their type a database
designer can store every information in the database in a logical way. After determining the
relationship, they can be mapped into the objects by using the database management system.
Why relational database approaches:
The relational database can save the details in the form of tables. Every data can be
accessible in different ways. By using the API and query language a user can access the data
that is store in the database. SQL commands can be used to record and retrieve the data from
database. A relational database is one type of database that can store and provide the data that
are interrelated. It is based on the relational model (Maatuk, and Rossiter, 2019). every table
in the relational databases contains several rows and columns (Song, Haw and Chua, 2018).
In the relational database, each row can be a unique row.
The meaning of the relational model is the logical structures of data in the form of
tables, views, and indexes that are different from the physical storage (Vonitsanos et al.,
2018). This difference can help any person to manage the data storage without affecting the
logical structure. For example, when a person changes the database name it will not affect the
table structure.
Why NoSQL database approaches are not appropriate in this scenario:

DATABASE SYSTEM3
NoSQL uses in such scenarios where are RDBMS unable to handle the required scale.
But in this database, scientists are mostly dependent on the SQL queries to retrieve the data.
NoSQL databases are appropriate for multi-object transaction. It is not ideal for this scenario.
The nature of this data is relational.
Differences and similarities between relational and NoSQL database approach:
When it comes to choosing a database in this scenario, one the of the biggest decision
is picking a NoSQL or SQL data structure. This is the most confusing decision because both
databases can effectively handle this scenario (Gessert, Wingerath, Friedrich and Ritter,
2017). The main difference is discussed below:
Type:
The SQL databases are relational by nature, while NoSQL database is called non-
relational databases (Bjeladinovic, 2018).
Language:
SQL databases are depending on the query language. It is one of the robust and
versatile languages that can perform complex queries. But it is worked on the predefined
schemas and each data follows the same structure (Solihin et al., 2017).
NoSQL databases work on the dynamic schemas. And it can store unstructured data.
it can store data in many ways such as column-oriented, graph-based or document-based
(Vyawahare, Karde and Thakare, 2018). Every document can follow their unique structure.
Structure:
SQL databases are tables dependent databases while NoSQL uses the key, graph and
document-based.