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:
- High level or Data Conceptual Model
- 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:
- Entity
- Attribute
- Relationship
Entity
The entity represents a real world object.
eg: Student, Employee
Attribute
The attribute represents the properties of the entity.
eg: Student name, Employee name.
Relationship
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.