Types of Data Models

Here I’m describing you the different types of data models in the DBMS. Before that let me explain what is the data model in DBMS system.

The data model is the collection of conceptual tools that can be used for describing the structure of data in the database.

A data model provides a way to describe the design of a database at the physical, logical and view levels.

Representation of data includes the data types, constraints, relationships and basic operations of the data.

The Types of Data Models

The data models in the DBMS can be categorized into two:

  1. High level or Data Conceptual Model
  2. Low level or Physical Data Model

High Level or Data Conceptual Model

The high-level data model provides concepts that are closed to the user perceive data.

Low Level or Physical Data Model

The low-level data model provides concepts that may be understood by end users but that is not too far removed from the way, data is organized within the computer.

Conceptual Data Model Terms

There are three terms in the conceptual data models. They are:

  1. Entity
  2. Attribute
  3. Relationship


The entity represents a real world object.

eg: Student, Employee


The attribute represents the properties of the entity.

eg: Student name, Employee name.


The relationship represents the association among two or more entities.

I hope this article might be helped you to understand the basics of types of data models in DBMS.

Tagged in: