Introduction and Types of the Database Model in DBMS
2 comments
:
Posted by:
Handy Hack
at
June 25, 2020
Tags:
Database
,
DBMS
,
handy hack
,
Hierarchical
,
Model
,
Network
,
Relational
Introduction
Data is nothing but information that becomes in something meaningful.
Database is the meaningful data arranged in a way that the data can be easily accessed, managed and updated.
DBMS stands for Database Management System. DBMS is the system that allows creation, definition and manipulation of database.
The main objective of the DBMS is to store the data to the server and retrieve the data from the database also. It can handle the large amount of data.
Some example of popular DBMS are MySql, Oracle, SQL Server etc.
Highlight: You can also watch below video for better understanding.
Types of Database Model
Database model can be classified into different categories which are describe below:
Hierarchical Model
In hierarchical data model, the data are represented as collection of records where nodes are connected with one to another through parent-child relationship.
Here the restriction of that this model has only one root node and a child node only have a single parent node.
Network Model
Network model is the extended version of hierarchical model. But In this model one child node can have more than one parent node.
Relational Model
This model consists of a collection of table which assigned with a unique name. These table consists of specified numbers of row and column. A row of table represents the relationship among a set of value.
Data is nothing but information that becomes in something meaningful.
Database is the meaningful data arranged in a way that the data can be easily accessed, managed and updated.
DBMS stands for Database Management System. DBMS is the system that allows creation, definition and manipulation of database.
The main objective of the DBMS is to store the data to the server and retrieve the data from the database also. It can handle the large amount of data.
Some example of popular DBMS are MySql, Oracle, SQL Server etc.
Highlight: You can also watch below video for better understanding.
Types of Database Model
Database model can be classified into different categories which are describe below:
1. Hierarchical Model
2. Network Model
3. Relational Model
Hierarchical Model
In hierarchical data model, the data are represented as collection of records where nodes are connected with one to another through parent-child relationship.
Here the restriction of that this model has only one root node and a child node only have a single parent node.
Hierarchical Model |
Network Model
Network model is the extended version of hierarchical model. But In this model one child node can have more than one parent node.
Network Model |
Relational Model
This model consists of a collection of table which assigned with a unique name. These table consists of specified numbers of row and column. A row of table represents the relationship among a set of value.
Relational Model |
Subscribe to:
Posts
(
Atom
)