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 −
But these days many new data models are being developed.
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.
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 −