Data Models in DBMS

Data models describe the structure in which data will be stored and retrieved. It consists of components for describing the data, relationships among them and the constraints that hold data. Different types of data models are hierarchical data model, network data model and relational data model.

Hierarchical Data Model: In this model, the data is organized into a tree like structure. The data is stored in the form of records. All these records are linked to each other at various levels, thereby forming a hierarchy.

Network Data Model: In this model, multiple records are linked to same master file. It is also considered as an inverted tree where master is present in the bottom of the tree and the branches contain information linked to the master.

Relational Data Model: This data model is based on the principle of setting relationships between two or more tables of the same database. This Model was proposed in 1970 by E. F. Codd. It is the most commonly used database model. The data is stored in different tables related through the use of common fields between them. That’s why this model is termed as relational database model.