Network Model in DBMS

January 25, 2023

Network Model

In DBMS, a network model is a way of organizing data in which multiple many-to-many relationships between records are represented using a graph-like structure. In this model, records are represented as nodes in the graph, and relationships between records are represented as edges connecting the nodes.

Network model in DBMS

In 1970s CODASYL (conference on data system language) introduced a network model which is an extension to the hierarchical model but the difference is that the network model uses many to many rather than one to many.
In 1970 IBM introduced IDMS(information data management system), a product based on the network data model.

Network data model

Data Organisation in the network model is just like a graph rather than a tree, a child record can have any number of parent records
This was the most widely used model before the relational database model was introduced

What is Database

Participation Constraint

DBMS Architecture

Data Models

Cardinality

Features of the network data model

It was introduced to overcome the drawbacks of the hierarchical model because the hierarchical model uses one to many relationship as a result only a few relationships can be established.
Many to many relationships: But here in network model It uses many to many relationship where the child only is allowed to have more than one parent node as a result large number of relationships can be applied with different data tables and data access becomes easier and faster .

Example for or network data model

Consider two tables “employee” table and “date of joining” table with the help of this network model more than one employee record can be linked to 2 more than and one record in the “date of joining” table
For example, as shown in the figure both admin and HR uses the same data row present in the date of joining table i.e [2014] as a result data duplicate is reduced .

Advantages of the network model

As more number of relationships or established between data tables it reduces data duplicity saves memory improve access time of data.

Prime Course Trailer

Related Banners

Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others