In hierarchical data model the data is stored in the form of
1 Pages329 Words426 Views
Added on 2019-09-16
In hierarchical data model the data is stored in the form of tree in the database in which there is root and all other nodes are the branches of the tree. The structureof the same consist of one to many and one to one relationship, also it does not provide data integrity because child node always depends on parent node for any manipulation.Advantage of this model is its simple structure, data security, the data stored in this is integrated and efficient, data is easy to add and delete. Disadvantage of thismodel is implementation complexity, managing database is a problem, lack of structural independence,programming complexity, limitation in implementing.In network model the data is stored in the form of multiple branches are associated from the node and it seems to be multiple tree are there. It does support many to many relation and the node can have multiple parent node as well as multiple child node.The advantage of network model is easy to access its data, it can handle more relationship type, data independence, data integrity. The disadvantage of this model is its system complexity, lack of structural independence and its proceduralaccess language.Relation model consist of relation between the table and their nodes. It does support all relation like one to many, many to many and one to one and it free from any anomalies like update or delete of node and if we delete a node it does not affect on other. The advantage of relation model is its ability to link information about a particularperson who is in several database together by simple links. The disadvantage of this model is that once the database is created it is not change easily so any database forming as part of relation database must be very careful planned.
Found this document preview useful?
Characteristics of Hierarchical, Network, and Relational Database Modelslg...
Logical Data Modeling Assignment PDFlg...
Database System for Jet Airlineslg...
Data Modelling SQL Language Tasks 2022lg...
Comparison of RDBMS with File Based System, Hierarchical, Network and Relational Database Modelslg...