Characteristics of Hierarchical, Network, and Relational Database Models

Data Modelling and
SQL Language

Table of Contents
INTRODUCTION...........................................................................................................................1
MAIN BODY...................................................................................................................................1
Task 1..........................................................................................................................................1
Characteristics of Hierarchical, network and relational database models and applications of
each.........................................................................................................................................1
Compare the SQL databases and No SQL databases.............................................................2
CONCLUSION................................................................................................................................3
References:.......................................................................................................................................4

INTRODUCTION
Data modelling can be defined as the building up of a data model for the data that is
required to be captured in a database. It is an abstract execution of data objects, the relations
between various data objects and the rules associated with it (Munir and Anjum, 2018).
Therefore, the following discussion is made on the characteristics of hierarchical, network and
relational database models and the difference between SQL and NOSQL database management
system with proper conclusion.
MAIN BODY
Task 1
Characteristics of Hierarchical, network and relational database models and
applications of each
Hierarchical database models
It is known as the most oldest type of the data model and developed by IBM in 1968
(Cao, Qian, Wu and Wong, 2019). It organises data in the form of three like structure and it has
the following characteristics: it consist nodes that are connected by various branches, top most
node is the root node, multiple nodes are known as the root segments, each node contains exactly
one parent, one parent can have many many child, it executes 1:1 and 1:n relations, child node
cannot be inserted without a parent node, it is difficult to erase the parent node, it lacks
independence of data and data uses is complex and asymmetric. &XML and XAML use this
model.
Network database models
It is known as the advanced version of the hierarchical data model because it uses
directed graphs instead of the three structure method (Cao, Qian, Wu and Wong, 2019). It consist
child more than one parent therefore it uses the conception of two data structure such as records
and sets. It manages records using links or pointers to one another, along with 1:1 and 1:n, it
also executes many to many relationships, it does not have any insertion anomaly and deletion
anomaly, it consist partial data independence and data used in this model is complex and
symmetric. VAX-DBMS, DMS-1100 of UNIVAC and SUPRADBMS's use this model.
Relational database models
1