1.

Differentiate between hierarchical database models and network in DBMS.

Answer»

Data are grouped into nodes in a tree-like structure in a hierarchical database model. A node can only have ONE parent node above it. As a result, the data nodes in this model have one-to-many relationships. The Document Object Model (DOM), which is often used in web browsers, is an example of this model.

The NETWORK database model is a more sophisticated variation of the hierarchical database architecture. Data is organised in a graph-like structure here as well. One child node, on the other HAND, can be connected to several parent nodes. A many-to-many relationship between data nodes is an outcome of this. Network databases include IDMS (Integrated Database Management System) and IDS (Integrated Data Store).

Hierarchical modelNetwork model
The relationship among the records is of the parent-child form.The relationship among the records is in the form of pointers or links
Inconsistencies in data may occur during the update and delete actions.Data inconsistencies do not occur.
It does not support many to many relationships between the data nodes.It does support many to many relationships between data nodes.
It generates a tree structure, and data traversal is a little complicated.It generates a graph structure in which data traversal is SIMPLE because each node may be accessed in both directions, i.e. parent-child and vice versa.


Discussion

No Comment Found

Related InterviewSolutions