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
Related Questions in this Topic
- Discuss about RDBMS and Object oriented DBMS with examples.
- Write short notes on the following: Distributed Database
- Describe the various types of files that can be created in SQL Server databases.
- In spite of the advantages of using a Database Management System (DBMS), there are a few situations or circumstances in ...
- What are the salient features of Hierarchical database ? Describe briefly.