What is a Data Model in DBMS?

DBMSDatabaseBig Data Analytics

It is a collection of concepts that can be used to describe the structure of a database. The structure of the database means data types, relationships and constraints that should hold the data nothing but it provides the necessary means to achieve the abstraction.

A Model is basically a conceptualization between attributes and entities.

There are basically three main data models in the Database Management System (DBMS), which are as follows −

  • Network

  • Hierarchical

  • Relational

But these days many new data models are being developed.

Components of data model

The data model can have three components which are as follows −

  • Structural part − It consists of a set of rules according to which database can be constructed.

  • Manipulation part − Defining the types of operations which are allowed on data.

  • Set of integrity rules − It ensures that the data is accurate.

Data Model Basic Building Blocks

The building blocks in the data model are as follows:

  • Entity − An entity represents a particular type of object in the real world.

  • Entity set − Sets of entities of the same type which share the same properties are called entity Sets.

  • Attribute − An attribute is a characteristic of an entity.

  • Constraints − A constraint is a restriction placed on the data. It is helpful to ensure data integrity.

  • Relationship − A relationship describes an association among entities.

Pictorial representation of Data Model

The data model is pictorially represented as follows −

raja
Published on 03-Jul-2021 09:43:43
Advertisements