Distinguish between the following: Hierarchical and network DBMS

CS Professional · Information Technology and Systems Audit · PYQS · December 2021
Distinguish between the following: Hierarchical and network DBMS

Answer & Explanation:

In Hierarchical data model, relationship between table and data is defined in parent child structure. In this structure data are arranged in the form of a tree structure. This model supports one-to-one and one-to-many relationships. On the other hand, network model arrange data in graph structure. In this model each parent can have multiple children and children can also have multiple parents. This model supports many to many relationships also. Key Hierarchical DBMS Network DBMS Basic Relationship between records is of the parent child type. Relationship between records is expressed in the form of pointers or links. Data Inconsistency It can have data inconsistency during the updation and deletion of the data. No Data inconsistency. Traversing Traversing of data is complex. Data traversing is easy because node can be accessed from parent to child or child to parent. Relationship It does not support many to many relationships. It support many to many relationships. Structure Its create tree like structure. It support graph like structure.

Topics: Database Management Systems

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic