A data model shows how the logical structure of your data is presented. it also specify how datas are related from each other and how can we store it within the system.
There are two types of Data models:
- Object based logical model
- Record based logical model
Object based logical model:
It is just the blueprint of database which are not related to each other. it contains Entity relationship model (for example employee data, department data and relation between them).
Record based logical model:
It contains three major types of data models.
- Relational data model
- Hierarchical data model
- Network data model
Relational data model is stored in the form of rows and columns (also known as tabular data)
Hierarchical data model contains trees and nodes (only one root node and many child nodes)
Network data model contains relation between relationship between various attributes with each other.
Read Below About DBMS Operators:-
To deal with the data you have-
- Modifying data
- Removing data
- Removing files
- inserting data
- Adding new files
- Retrieving data
DBMS comes with enhanced security mechanism, fluent sharing of data across applications, better transactional support, and recovery & backup features.
Also read : How to apply joins in python using pandas library